azurepowerbiazure-logic-appspowerbi-paginated-reports

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

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.

enter image description here

enter image description here

enter image description here

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

EDIT: more info

enter image description here

Solution

  • 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 https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to