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'.
Microsoft Flow is able to read my alerts from Power BI (ie the alert names are appearing in a drop down) 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. When I click on it, it outputs the below detailed 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
}
}
}
}
I originally posted this with links to screenshots but for whatever reason it was marked as spam. I suspect it's due to the links. I'm reposting again without the screenshots, so hopefully there's enough info to help troubleshoot! Thank you so much in advance for your help.