PowerBINotAuthorizedException error in Power BI Flow

[freswood]

Hi there,

I've been trying to set up a flow that will send an email to a distribution list when a Power BI alert is triggered. I've been using the template called 'Send an e-mail to any audience when a Power BI data alert is triggered'. When I try to create the flow I get the error 'PowerBINotAuthorizedException'. The steps I followed and full error details are below.

This is what the connections look like when I set up the flow: https://imgur.com/SSioz0c

This is what the flow looks like: https://imgur.com/COQsHm9

It's able to read my alerts from Power BI so it's clearly connecting to it. Once the flow is set up and I click on it, there's an error message to fix the trigger: https://imgur.com/i7BwBbR

When I click on the above it outputs the below error message:

{

"statusCode": 401,

"headers": {

"Pragma": "no-cache",

"Retry-After": "600",

"Strict-Transport-Security": "max-age=31536000; includeSubDomains",

"X-Frame-Options": "deny",

"X-Content-Type-Options": "nosniff",

"RequestId": "71d3b2f8-f444-433e-b2ab-352c5c194a56",

"Access-Control-Expose-Headers": "RequestId",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "false",

"Cache-Control": "no-store, must-revalidate, no-cache",

"Date": "Wed, 11 Sep 2019 04:58:29 GMT",

"Content-Length": "220",

"Content-Type": "application/json"

},

"body": {

"error": {

"code": "PowerBINotAuthorizedException",

"pbi.error": {

"code": "PowerBINotAuthorizedException",

"parameters": {},

"details": [],

"exceptionCulprit": 1

}

}

}

}

[manuelstgomes]

Hi @freswood 

This happens once in a while. You need to remove and add the trigger. I know it's stupid, but this is some case of inconsistency in the Power Automate's permissions that triggers this.

In my case it happened to me and this was the only way to get it to work.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel