Question 295480 in Azure Question posted in
The official documentation to get you started can be found here.

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

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    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


  2. 0

    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
    enter image description here

    Click on edit credentials

    enter image description here

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

    enter image description here

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

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search