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:
Solved! Go to Solution.
Hi @freswood ,
Could you please share a screenshot of the configuration of your flow and the error message?
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks so much for your reply! Below are some screenshots, but please let me know if I've missed anything. Thank you so much for your help!
I ran into the same issue today. Between the error message and taking a peek at the code I took a long shot and tried sharing the report with myself. This fixed the issue in my case (or Microsoft just resolved things at the same time).
That may work as a temporary workaround until the bug gets resolved and it's a pretty easy thing to test.
Also maybe worth noting, my dashboard is in an old workspace, not a new workspace. Not sure if that maybe makes a difference?
Sharing the report and dashboard with myself solved the issue. Bizarre, but happy to have a workaround until it's really fixed!
Thank you for posting your findings!
Hi @sam_revak, how do you share the report with yourself? Below is a screenshot of what it looks like when I click on 'Share' before making any changes. I'm already the owner, so when I search for myself in the search box and click on my name, it doesn't seem to do anything. Apologies if this is a silly question - I'm brand new to Flow.
I ran into the exact same error today. Shared the dashboard with myself but still getting the PowerBINotAuthorizedException error.
Tried deleting and recreating the Flow, dashboard tile, and Power BI alert, re-sharing, same error
I'm having the same problem. Sharing the report and dashboard with myself doesn't solve the problem. The weird thing is, when I made the flow, it worked. Now, 3 weeks later, I'm getting this error.
When i try to recreate the flow from scratch, I'm still getting the same error.
Edit: I fixed the error by triggering the alert within Power BI before making the flow. My alert wouldn't actually trigger because the conditions were not met, so I first set my treshold so high that it HAD to trigger. After it triggered, I set it back to its intended value and made the Flow. This method works consistently for me.
The post marked as the solution worked perfectly for me. You just need to share the Power BI dashboard with yourself - bit weird but it works.