Azure Logic Apps Export to file from paginated report not working 401 Unauthorized

Question

i have a simple flow in azure logic apps: 1- reccurence. 2- Export to file from paginated report as excel. 3- email the excel file.

but the second has an error, says Unauthorized code 401.

the power-bi paginated report is connected to my azure database server with the sql server crediatials.

note: the paginated report doesnt have parameters.

i hope you can guide me to a solution for that.

EDIT: more info

Answer 1

apparently, premium-per-user is not enough to have access to export from power bi. https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to

Answer 2

Please try below steps. Seems like an issue with the dataset in power bi.

Got to paginated report and click on edit in PBI report builder

Click on edit credentials

Change authentication to OAuth and tick the box and sign in.

It is a bug in the API that can't pass through an identity token