Forum Discussion
Unauthorized Power BI Connector
Hi all,
I have thirty scheduled flows that sends emails when the Power Bi alerts are triggered.
The majority of this flows are working properly, but there are some of these that are failing without any explanation. (These alerts are the same to all the flows, but the filters change).
F.E. If we sell something in America, we send an email to the America's managers.
The error message that appears to me is the next:
Error Message
IMPUTS:
Previous Menu
I've been searching in the forum for a related or similar issue, but the unique solution proposed is to call Microsoft Technical Support, and for that I need a premium account.
18 Replies
Hi @sannicolasalex ,
Have you tried updating the connection or re-creating the connection?
Please try doing the following and see if the error still exists:
- Click Save as to create a copy of Flow, then turn on Flow and configure where it may need to be configured, and finally see if this copy is available.
- Alternatively, you could export this Flow as a .zip file and re-import it as a new Flow. After doing the relevant configuration, check if similar problems still exist.
Hope it helps.
Best Regards,
Thanks @v-bacao-msft , I had tried but without success.
I tried the two proposed ways. The "unauthorized" message still appearing.
Hi @sannicolasalex ,
Please check if the current group to which your current workspace belongs is a public group.
I'm afraid I'm not particularly familiar with Power BI's permissions, but I did the following tests to reproduce your problem and seem to find the cause of the problem.
If the current group is a private group, then the Owner needs to publish the application to share to the specified group or users within the organization, such as you.
Then you can add a new alert rule based on the app that has already shared with you and reconfigure the Flow.
This problem should be solved. Here is a screenshot of the Flow I created:
Best Regards,
Hi all,
I also have this same problem, does anyone have any idea what we can do?
Tanks for help me..
Best Regards..
@sannicolasalex wrote:Hi all,
I have thirty scheduled flows that sends emails when the Power Bi alerts are triggered.
The majority of this flows are working properly, but there are some of these that are failing without any explanation. (These alerts are the same to all the flows, but the filters change).
F.E. If we sell something in America, we send an email to the America's managers.
The error message that appears to me is the next:
Error Message
IMPUTS:
{"host": {"apiId": "subscriptions/ac07fa44-4742-482d-aa28-c00945932935/providers/Microsoft.Web/locations/westus/runtimes/msmanaged-na/apis/powerbi","connectionReferenceName": "shared_powerbi","operationId": "CheckAlertStatus"},"parameters": {"alertId": "27914_"}}OUTPUTS:{"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": "4aa9526c-8416-4dd1-afc8-44a7656acc0d","Access-Control-Expose-Headers": "RequestId","Timing-Allow-Origin": "*","x-ms-apihub-cached-response": "false","Cache-Control": "no-store, must-revalidate, no-cache","Date": "Thu, 26 Sep 2019 09:53:30 GMT","Content-Length": "220","Content-Type": "application/json"},"body": {"error": {"code": "PowerBINotAuthorizedException","pbi.error": {"code": "PowerBINotAuthorizedException","parameters": {},"details": [],"exceptionCulprit": 1}}}}Previous Menu
I've been searching in the forum for a related or similar issue, but the unique solution proposed is to call Microsoft Technical Support, and for that I need a premium account.
I'm having a similar issue. All existing flows using Power BI alerts are working fine. But I cannot create new ones. They just say "Unauthorized"
The full text of the body of the error message is:
{ "error": { "code": "PowerBINotAuthorizedException", "pbi.error": { "code": "PowerBINotAuthorizedException", "parameters": {}, "details": [], "exceptionCulprit": 1 } } }My Power BI connectors in Flow are ok. All existing flows using the Power BI connectors work fine. I just cannot create new flows.
I also have the same problem, I hope Microsoft will fix it.
