We have had a series of executive reports that are being delivered daily using power automator that have suddenly strated failing in the last 5-6 days. These reports have been running since late 2021 and there were no changes on our behalf.
It appears the steps to recreating this are as follows:
* Create a Power BI report, that uses directquery for power bi to use another report as a data service.
* Publish this report (we are using a Preimium per capacity server)
* Create a power automate job that uses "export to file" to export this report to a PPTX or PDF.
* The job fails after multiple retries.
The Power Automator job reports the Power BI failure as "BadGateway".
on:
URGENT!! Paginated Report not loading on Mozilla F...
mattlee
on:
“Add Value” in Textbox Not Visible in Dark Theme
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
on:
Fix the Date function in DAX
As far as I know, seems like Power Automate has no clear limiations about the 'threshold or rate', see:
Export and email a Power BI report with Power Automate
You can considet the limiations for export to PDF itself from Power BI Service:
Export reports from Power BI to PDF
In addition, since you have mentioned that only Direct Query would be affected and the error is about 'BadGateway', whether these reports have configured correctly by the gateway.
Best Regards,
Community Support Team _ Yingjie Li