cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swagath
Frequent Visitor

Export Power BI Report to PDF through Subscription

We have a situation that we want to create a subscription to export the Power BI report to PDF. We do not have a Premium capacity license. Is there any workaround to create a subscription with PDF export or Export the Power BI report using REST API or PowerShell?

 

Please advise and Thanks in advance   

8 REPLIES 8
Eyelyn9
Community Support
Community Support

Hi @swagath ,

You could use REST API to export to PDF, please take a look at this  official document  for more information.

 

Best regards,

Eyelyn Qin

swagath
Frequent Visitor

@Eyelyn9  Thanks for your response. We do not have a Premium capacity license, so it is throwing below error. We need to implement this functionality on the workspace which was not created using Premium capacity. 

 

Export To PDF.png

krajani
Helper V
Helper V

You can schedule a PowerShell script to save your Power BI report as PDF, and other formats. 

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

 

Once exported as PDF, you can then send it out as an email attachment. If it is a simple report where everyone can see all the data, then it is going to be very simple. If you have RLS implemented then you'll have to work out your options.

 

Let us know how you go.

Thanks
Kaz

swagath
Frequent Visitor

Hi Kaz,

Thanks for your response. We do not have a Premium capacity license, so it is throwing below error. We need to implement this functionality on the workspace which was not created using Premium capacity.Export To PDF.png

Sumanth_23
Super User
Super User

hi @swagath - You can subscribe reports for yourself and others in Power BI even without Premium licence. You can refer to the detailed documentation on the same in the below link

 

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe

 

Do read the "Considerations and troubleshooting" section; also when you subscribe to the report a snapshot of the report will be atatached to the email. 

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

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

Proud to be a Super User!



@Sumanth_23  Thanks for your response. The default subscription does not contain export to PDF, it allows only .png export. We need to implement Export to PDF. That's I'm looking other solutions through API and PS combination   

 

Thanks,

Fowmy
Super User
Super User

@swagath 

This link could be of help to you

https://christopherfinlan.com/2019/04/27/use-microsoft-flow-to-archive-pdfs-of-your-paginated-report...

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

swagath
Frequent Visitor

@Fowmy  Thank you for your response. We are using Power BI reports, not the paginated reports. Do you think Flows works exporting to PDF for Power BI reports? Please advise

 

Thanks, 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.