Auto bulk export of reports to specified location

[soarryan]

We have reports published to Power BI Service with slicers that filter by category. There are 1000+ category values. There is a requirement to periodically export a PDF for each category value and store them in a specified folder location.

Is this possible to do with Power BI Service? I know that a similar thing is doable with subscriptions, but this supports email delivery. Can Power BI Service do automated exports of reports to a folder?

[christinepayton]

There's a brand new Power Automate action for creating dynamic subscriptions of paginated reports that MIGHT do it (I haven't used it yet), Guy in a Cube did a video on it here: The Secret to Data-Driven Dynamic Subscriptions in Paginated Reports - YouTube

You could absolutely put the outputs of any of the Power Automate actions into SharePoint locations, though, and you can for-each loop them on pretty much anything you want... so if the new action doesn't work  for this you can probably use one of the older paginated queries to dynamically query and export based for-each of the categories in a list of categories. 

[soarryan]

Thank you! I will look into this video.

Would you know if this type of functionality be doable with regular reports, or only paginated reports?

[christinepayton]

The pushing it to PDF in automation is a paginated thing I think. If you want it to look like the report did, anyway.