Forum Discussion
Automatically Convert PowerBI file to PDF with Pro License
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
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)
Yes, you can automate the PDF conversion process from your local or personal workspace using Power BI’s Power Automate integration or by leveraging Power BI Report Builder and scheduled tasks. Here’s an approach that could work well for you:
1. Using Power Automate Desktop:
- Set up a Power Automate flow** that triggers at specified intervals or based on a file update.
- In the flow, use **Power BI Desktop** to refresh the data and export it to PDF.
- After the export, the flow can save the PDF to a designated folder or email it to relevant recipients.2. Power BI Report Builder and Task Scheduler (Offline Process):
- Design the report in **Power BI Report Builder**, which is ideal for paginated reports and offers a straightforward export to PDF.
- Set up a Windows Task Scheduler job to open the PBIX file, refresh it, and export it to PDF.
- PowerShell scripts or Python scripts can automate this process further, especially if your data refresh requirements are minimal.3. Power BI Service Options for Local Workspaces:
If you’re using **Power BI Service**, you can also automate the process using Power Automate by connecting your personal workspace to create and export reports to PDF.
