Error “Report requested for export is not on dedicated capacity”

[PranP]

Problem statement: I am having Power Bi pro license. I am creating power automate flow to export image in PNG format from power bi ‘Export To File for Power BI reports’ action and then dumping that image on OneDrive and sending that email to required audience, however when I am testing the below flow it is failing with error “Report requested for export is not on dedicated capacity”

Question: Could you please let me know what are the pre-requisites to make this flow run?

Power Automate flow to export power bi report into PNG format(below snip)

[Syndicate_Admin]

Did you manage to fix the error?

[Anonymous · Accepted solution]

Hi @PranP ,

You may take a look at this blog.

https://blog.crossjoin.co.uk/2020/04/27/calling-the-power-bi-export-api-from-power-automate-part-2-c... 

• Azure Power bi resource name embeeded app must be running BEFORE you login into the "try it" button of the API documentation page. and then (copy pasted from the refered blog). I was pausing the app while finding the solution to stop the billing counter.

• Export To File In Group must be called first, to start the process of exporting either a Power BI report or a paginated report to a file. Exporting may take some time, though, so the exported file doesn’t get returned at this point. In the headers of the response there is a retry-after value in seconds telling you how long you must wait initially, before…
• …calling Get Export To File Status In Group to find out whether the export is ready or not. If it isn’t ready you again need to wait the number of seconds specified in the retry-after header before checking the status again. If it is ready, you can then…
• …call Get File Of Export To File In Group to download the export file.

Best Regards,

Jay