Power Automate: Export to File for Paginated Reports: times out

[sasdfasdfsad]

Following this learn document, it works fine for files that return low rowcounts, but larger files will time out.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-paginated-onedrive-sha... 

I can open the paginated report in the PBI service and export file to CSV just fine.

When I run it via Power Automate though, it will fail.

"error": {

    "code": "BadRequest",

    "message": "HTTP request failed: the server did not respond within the timeout limit. Please see logic app limits at https://aka.ms/logic-apps-limits-and-config#http-limits."

Is there any simple workaround for fix for this?

For business reasons this has to be done with Power Automate (I know I wish I could just access the direct source of the data that the PBI model is pulling from, but that isn't an option, has to be with Power Automate).

Thank you

[lbendlin]

It might be worth spending some time to optimize and declutter the paginated report so that the rendering can complete faster.

[v-aatheeque]

Hi @sasdfasdfsad 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

[Jai-Rathinavel · Accepted solution]

@sasdfasdfsad 

I can see your flow had run for 1 hour (60 mins) because of that the user token might have got expired as stated in this documentation Considerations & Limitations  and please note that "Export API for PPU, paginated reports is limited to one call every 5minutes, per user" [Reference]. 

As a workaround please trying querying the underlying semantic model and store the result as a csv file to a sharepoint location like below

https://pbi-guy.com/2023/02/03/export-paginated-reports-automatically-in-a-low-code-way-without-powe...

Thanks,
Jai

[v-aatheeque]

Hi @sasdfasdfsad 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.