Forum Discussion
Automatically Convert PowerBI file to PDF with Pro License
Hi everyone, I have a Pro license in my organization. Without upgrading to a Premium license, is there a way to automate the process of converting my Power BI files to PDFs using Power Automate or Python? Currently, I open my file, press Ctrl+P, and save it as a PDF manually. I’m looking for an easier solution. All the posts I found online use a Premium license. I need a solution for this.
Hi analyticsrookie ,
Please try report Subscription and Flow.
Reports under the pro license can only be exported as image previews instead of PDF.
So we can use flow to convert images into pdf.
Sample:
If you have 2 pages in the report, then you need to create two subscriptions. The first subscription is for previewing the first page and the second subscription is for previewing the second page.
Best Regards,
Wearsky
9 Replies
Hi,
With Pro License, yo can subscribe to the report and you will get a pdf in the email. Would that work for you?
Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn
My DAX codes in the Power BI files change frequently, and publishing them takes a lot of time because I have to follow my company's protocols. Is there a way to automate the PDF conversion process from my local or personal workspace?
Yes, you can subscribe the reports in your own (my workspace)
Hello analyticsrookie ,
Yes, It can be done using power automate(with pro ) and python.
A) Using Power Automate :
1. Open Power Automate and create a new scheduled or instant flow.
2.Use the "Power BI - Export to File for Power BI Reports" action.
3. Choose the workspace, report, and page you want to export.
4. For file format, select PDF.
5.Add a step to save the file to OneDrive, SharePoint, or send via email.
your flow will look like
Make sure to set proper connections and parameters along with schedule:
This will work only in Power BI Service not in desktop
Using Python
You can write custom python code to achieve the same
I hope this helps .
Did I answer your query ? Please merk this as solution . Appreciate your Kudos 🙂
Cheers
I actually tried this and got the below mentioned error
I think we might need premium for it
Hi analyticsrookie ,
In fact, calling action in power automate is the process of calling power bi api.
At my knowledge, It's a limitation.
https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to#license-requirements
Best Regards,
Wearsky
So I cannot automate the conversion to a PDF file from my local with a Pro License right?
Hi analyticsrookie ,
Please try report Subscription and Flow.
Reports under the pro license can only be exported as image previews instead of PDF.
So we can use flow to convert images into pdf.
Sample:
If you have 2 pages in the report, then you need to create two subscriptions. The first subscription is for previewing the first page and the second subscription is for previewing the second page.
Best Regards,
Wearsky
