cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sallen1
Level: Powered On

Flow fails due to issue connecting to Power BI alert

Hey guys, hoping you can help me. I've created a simple alert that emails a group of people when a Power BI alert is triggered. For some reason the flow is failing and the issue is in connecting to the Power BI alert.

 

The error code is:

Capture.PNG

 

The full error text in that bottom scroll window is:

{
  "error": {
    "code": "MalformedQueryResult",
    "pbi.error": {
      "code": "MalformedQueryResult",
      "parameters": {
        "AlertId": "19133",
        "TileId": "14216948"
      },
      "details": [],
      "exceptionCulprit": 1
    }
  }
}

I made this flow by following the link from Power BI in the alert window (it says "Use Microsoft Flow to trigger additional actions") so the connection seemed to work fine when I set up the flow.

 

Not sure what other information to provide. Any help would be greatly appreciated, this alert has become kind of important at work and the fact that it is failing is kind of embarassing =S.

 

Thanks!

 

12 REPLIES 12
Community Support Team
Community Support Team

Re: Flow fails due to issue connecting to Power BI alert

Hi @sallen1,

 

What’s your current situation? Are you still having the issue?

Please make sure you are using correct Alert Id in the trigger.

 Generally, error message bad request means that a setting in an action of the flow doesn’t function as expected.

Please correct the problem inside the flow definition by editing the flow, then save the updated flow.

Please check it again.

If you are still having the issue, please feel free post back.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Administrator
Administrator

Re: Flow fails due to issue connecting to Power BI alert

Hey, @sallen1!

Thank you for posting on the Flow Community Forum! It appears as though @v-yamao-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

-Gabriel
Microsoft Flow Community Manager
JoelPhillips
Level: Power Up

Re: Flow fails due to issue connecting to Power BI alert

I'm having this problem as well. I've selected the Alert ID from the dropdown, and I am getting a BadRequest Error 400. Was any solution found for this problem?

sallen1
Level: Powered On

Re: Flow fails due to issue connecting to Power BI alert

I actually wasn't able to fix the flow so I just re-created it from scratch and it worked fine. I wish I could be more helpful but I'm not sure what the issue was.

Behen
Level: Power Up

Re: Flow fails due to issue connecting to Power BI alert

I am experiencing the same issue.

The PowerBi Alert is selected from the dropdown list, so an incorrect AlertId seems unlikely.

I tried recreating the alert and flow, but this makes no difference.

 

Does somebody have a solution for this problem?

 

The error message I'm getting with statuscode 400:

{
  "error": {
    "code": "MalformedQueryResult",
    "pbi.error": {
      "code": "MalformedQueryResult",
      "parameters": {
        "AlertId": "39377",
        "TileId": "21778977"
      },
      "details": [],
      "exceptionCulprit": 1
    }
  }
}
LEEY
Level: Powered On

Re: Flow fails due to issue connecting to Power BI alert

Same issue here, I tried recreating the Flow from scratch and nothing changed. Is there already a solution? I am running 6 reports from the same Power BI and everything else is the same, but only 2 of them have this issue with the trigger. 

 

Power BI Trigger Error 1.pngPower BI Trigger Error 2.pngPower BI Trigger Error 3.png

LEEY
Level: Powered On

Re: Flow fails due to issue connecting to Power BI alert

Power BI Trigger Error 4.pngPower BI Trigger Error 5.png

Behen
Level: Power Up

Re: Flow fails due to issue connecting to Power BI alert

I've fixed my problem, it was a configuration error of the power bi alert Smiley Embarassed

 

I had created a measure on which I defined the alert, the measure compared some values and returned True() or False(). I assumed that this corresponded with 1 and 0 but this is not the case! 

PowerBi doesn't complain when configuring the alert this way, but you will never get an alert Robot Sad 

 

After I adapted the measure to return 1 & 0 instead of True() & False(), everything worked like a charm.

 

LEEY
Level: Powered On

Re: Flow fails due to issue connecting to Power BI alert

@Behen thank you for sharing, can you elaborate a bit more about how you re-configure your Power BI Alert from True/False to 1/0???? Because at my Power BI Alert management I can only see the option as screenshot below. Thanks!

Power BI Trigger Error 6.png

Behen
Level: Power Up

Re: Flow fails due to issue connecting to Power BI alert

@LEEY I adjusted the measure on which I configured the alarm to return 1 or 0 instead of true or false.

In the power bi management I have the same options as you Smiley Happy 

 

LEEY
Level: Powered On

Re: Flow fails due to issue connecting to Power BI alert

@Behen I meant where do you do such adjustment? I don't see such option at my Power BI Alert management. Can you share some screenshots to walk us through. Thank you.

Behen
Level: Power Up

Re: Flow fails due to issue connecting to Power BI alert

@LEEY  Aha, sorry, i misunderstood !

 

The adjustment is done in the powerbi report itself. So in my case:

- Download the report

- Open it with powerbi desktop

- Do the adjustments to the measure which is displayed in the card

 

Example old measure: 

MyMeasure = 
var MyCondition = sometest
return
if(MyCondition; TRUE(); FALSE())

Adjusted measure:

MyMeasure = 
var MyCondition = sometest
return
if(MyCondition; 1; 0)

 

- Publish the report again

- Pin the card to a dashboard & set the alarm on the numeric value

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 52 members 4,388 guests
Please welcome our newest community members: