Forum Discussion
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
9 Replies
- FowmySuper 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-reports-in-power-bi/________________________
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 🙂
- AnonymousNot applicable
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!
- swagathFrequent Visitor
Anonymous 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,
- AnonymousNot applicable
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- swagathFrequent 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.
- AnonymousNot applicable
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
- swagathFrequent Visitor
Anonymous 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.
- mruizprieto17Frequent Visitor
Hello,
Did you solve This problem? I am staying in the same situation. I am developing similar script but told me that it is neccessary to cacpacity premium