Unanswered

Flow fails due to issue connecting to Power BI alert

(1) Share

Report

Posted on by sallen1

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:

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!

All responses (12)

Answers (0)

Community Power Pla... on at

Like (0)

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

@Anonymous 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
Community Power Pla... on at

Like (0)

Report

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

@Anonymous 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.
Community Power Pla... on at

Like (0)

Report

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

@Anonymous 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 🙂
Community Power Pla... on at

Like (0)

Report

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

@Anonymous 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!
Community Power Pla... on at

Like (0)

Report

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

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

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

Like (0)

Report

Re: Flow fails due to issue connecting to Power BI alert
Community Power Pla... on at

Like (0)

Report

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.
Community Power Pla... on at

Like (0)

Report
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 } } }
sallen1 4 on at

Like (0)

Report

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.
JoelPhillips 4 on at

Like (1)

Report

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?