Programmatically Save PDF's to Fileshare/OneDrive

[seadude]

Hello,

Does PowerBI Service OR PowerBI Report Server have the ability to save report PDF's to a fileshare/OneDrive folder on a schedule?

Example:

- Every day at 0300

- Save each of our customer reports, as a PDF, to a customer folder in OneDrive or to an on-prem fileshare

Does anyone know how to get static files out of Power BI on a schedule?

Thank you

[Greg_Deckler]

I would use PowerAutomate (Flow) to do that coupled with the Power BI REST API.

[seadude]

@Greg_Deckler, I'm thinking something like this:

https://docs.microsoft.com/en-us/power-bi/service-url-filters.

Need to able to pass filter parameters to the API. Ever tried this?

[seadude]

@Greg_Deckler,

Ii don't see a API call that can pass parameters to a Report. Do you know how this is accomplised?

Example:

- I have 200 customers

- I want to programmatically send them each a filtered version of the same Report in PowerBI
- How can I send PowerBI the filter query via REST and get the filtered Report as a response?

Is the only way to create a 200 page Report then use the Get Page API?

Thanks!

[Anonymous · Accepted solution]

Correct.

[Anonymous]

hi @seadude 

Until day before yesterday its not possible.  Yesterday MSFT announced a new REST API to programmatically export the report as PDF or PPTX or PNG file.

Refer : https://powerbi.microsoft.com/en-us/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest...

You can build automation to export and store it automatically to the onedrive folder or shared drive folder.

Did I answer your question? Mark my post as a solution!

[seadude]

For posterity,

Here are the REST docs I was looking for: https://docs.microsoft.com/en-us/rest/api/power-bi/

Will try @Greg_Deckler 's idea.

THanks!