Forum Discussion
Power BI Embedded: Paginated reports extremely slow to export via REST APIs
Hi Meesha ,
Suggest you use Power Automate's HTTP action to try placing the bearer token directly inside the request header, and then test whether the performance will be faster than a third-party API tool like postman? Because Power Automate is a tool provided by Microsoft to automate the running of a combination of Microsoft services and APIs, it can be realized that the return of the previous API is populated into the next API, see these links for details:
Using the HTTP action to make requests with Microsoft Flow - Microsoft Power Platform Blog
Overview of the cloud flows - Power Automate | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liu Yang,
Thanks kindly for the response, I work with Manisha on this project.
I would be surprised if that solution offered any improvement - the actual fields in the Export object returned by Get Export To File Status In Group indicate an average 23 second elapsed time between "CreatedDateTime" and "LastActionDateTime". I may be able to carve some time out today to implement this in Power Automate, but given that we have the response indicating that the processing time is so high on Power BI's side of things, I suspect we'll see the same behavior.
This is an unexpected performance hit that jeopardizes an entire project. We badly need to see that 23 seconds reduced to something more reasonable, such as the time that it takes to render the reports on Microsoft's own interface at powerbi.com, where it is a matter of seconds in the single digits.