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!

Categories:

Using connectors

I have the same question (0)

All responses (12)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GabrielStJohn Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
JoelPhillips 4 on at

Like
a
(1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
sallen1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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 } } }

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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 🙂

Was this reply helpful? Yes No