Power Automate Flow error: 'Export_To_File_for_Paginated

Power Automate Flow error: 'Export_To_File_for_Paginated_Reports' failing

I have a simple flow with two components, a manual trigger and then a 'Export to file for paginated report' which is configured with the workspace and the paginated report that is available on Power BI service.
When I test the flow it is failing with error

Kindly guide on how to resolve this issue.
Thanks for your time.

Categories:

Process Advisor

Licensing

Hi Good day,

Based on the screenshot the error message is showing unauthorized from the power bi action, Please try the following;

1. Verify Permissions:
Power BI Service Account: Ensure that the account you’re using to run the flow has the necessary permissions in the Power BI workspace where the paginated report is located. This account should have at least Viewer access to the report.
Power BI Pro or Premium License: Make sure that the account has a Power BI Pro license or that the workspace is hosted on a Power BI Premium capacity, as exporting paginated reports typically requires one of these.
2. Check Connection in Power Automate:
Go to the Data section in Power Automate and review the connection you're using for the Power BI action. Make sure it is valid and not expired.
Try refreshing the connection by re-authenticating it. Sometimes, renewing the connection can resolve authentication issues.
3. Set Up the Flow with Correct Authentication:
If the flow is running under a service account or a different user context, ensure that the account has been granted access to both the Power BI workspace and the specific paginated report.
4. Check for Row-Level Security (RLS) and Restrictions:
If the paginated report uses Row-Level Security (RLS) or other access restrictions, ensure that the account executing the flow has access to the data in the report. The unauthorized access error could stem from these restrictions.
5. Test Access Outside Power Automate:
Try to access the paginated report directly in Power BI Service with the same account to ensure there are no access issues. If you can export the report manually, it confirms that the account has sufficient access.

Kindly feel free to like my post and mark my response as a solution if it meets your requirement

Quick Links

Leaderboard > Power Automate - General Discussion