Power BI Service - Workaround for Subscription Limitation (Output to file directory)

Hi MichaelP2020 ,

I believe that the way to do it is to use the API and Flow to save the report to a location.

You can use the API to export the file

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile

Here is an example of svaing a report to OneDrive:

https://flow.microsoft.com/en-us/galleries/public/templates/f4fc8bed6e384f5f89bb3b980d152f47/save-a-power-bi-paginated-report-to-onedrive-for-business/

And, a similar example by Erik Svensen here:

https://eriksvensen.wordpress.com/2020/09/29/setup-data-driven-report-subscriptions-for-powerbi-paginated-reports-with-powerautomate/

ANd, Chris Webb has some blogs about using the API's:

https://blog.crossjoin.co.uk/category/power-bi-api/

So, I know none of these are the exact precise answer but combined I think they will guide you down the path.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!