Automating PowerBI report Export for Pro License

[Manish18]

Hi all,

I want to automatically export a powerBI report 200 times, each time with a different filter. I have a PowerBI Pro license and don't want to upgrade it to capacity (I know Power Automate provides this feature for Premium per Capacity users). Can anyone please help me with this.

Thanks!

Manish

[v-yiruan-msft · Accepted solution]

Hi @Manish18 ，

There are two prerequisites for using Power Automate to export Power BI reports as follows:

• At least one workspace in your Power BI tenant backed by a reserved capacity. This capacity can be any of the A1/EM1 - A6/P3 SKUs. Read more about reserved capacities in Power BI Premium.
• Access to the standard connectors in Power Automate, which come with any Office 365 subscription.

Which mentions its need for reserved capacity. I'm afraid there is no other elegant way to achieve this requirement without upgrading to premium capacity. You can raise a new idea and add your comments there to make this feature coming sooner.

Best Regards