Michael Steedle on 15 May 2024 20:26:26
Using Power Automate to generate exports from Power BI reports uses 400.0000 CUs per page exported, a significant dent in your dedicated capacity. This is unreasonably high for the operation and makes using the exportToFile API infeasible at any scale. I have never been able to detect any impact from on-demand report exports in the browser, so it defies explanation that you are penalized so highly for using the exportToFile API.