How to schedule a Power BI Report Automatically to Email In PDF Format

[gauravnarchal]

Can I automate (schedule) Power Bi reports in PDF format? 

If yes, how?

If no, any way reports in PDF can be scheduled?

[lbendlin]

here is an exampe implementation of the process

Solved: Power BI REST API gives 403 error - Microsoft Power BI Community

[v-easonf-msft]

Hi , @gauravnarchal 

Could you please tell me whether your problem has been solved?
For now, there is no content of description in the thread.

You also can share your sloution to us, people who meet a similar problem will be very happy with it.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi , @gauravnarchal 

It is only supported for Paginated reports   if you have Power BI Premium license currenctly. 

https://powerbi.microsoft.com/en-us/blog/e-mail-subscriptions-for-paginated-reports-is-now-available...

Power BI has no automation feature present to auto export to PDF and email it after the export.

As a  workaround ,you can send PDF using Microsoft Flow but  need to export Power BI reports to PDF manually first.

For more details ,please refer to these related threads.

https://community.powerbi.com/t5/Service/Automatically-generate-save-a-dashboard-report-as-a-pdf-and...

https://community.powerbi.com/t5/Service/Send-report-PDF-in-email-using-Flow/m-p/819871

You also can  vote up the ideas  on Power BI Ideas forum. If there are enough votes, the Product Team will evaluate and take good consideration about it. 

https://ideas.powerbi.com/ideas/idea/?ideaid=c25b964d-71f2-4867-9717-a565ccd4b948

https://ideas.powerbi.com/ideas/idea/?ideaid=657665fe-0817-4738-9c7b-9b37630d6430

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You cannot schedule reports. You can schedule dataset refreshes.

I think what you are asking is if you can schedule report extract to PDF. The answer to that is yes.  Use either Powershell or Power Automate to issue the required REST API commands.  Be aware that this is a multistep process

- request a dataset refresh (optional)

- monitor dataset refresh status, wait for completion (optional)

- request extract of report to PDF

- monitor rendering completion, wait for the file to be ready

- retrieve the rendered PDF

- attach it to the email and send the email.

All this can be done in Powershell or Power Automate - or whatever automation tool you prefer that can issue basic HTTP commands.

[Anonymous]

Where can I get those commands to do those steps?

Thank u