Forum Discussion
Sharing the report
I created a 1 pager table report with scroll bars. I would like to share this report to non technical team twice daily , printable pdf format and save in share point as pdf.
I tried to create a power automate but failed.
Could any one share step by step process to achieve this.
Hi swathrddy ,
You indicated that your Power Automate workflow was unsuccessful, which may be due to licensing issues.
Before proceeding, please verify the following:
The Export to file for paginated reports or Export report to file features in Power Automate require either:
A Power BI Premium Per User (PPU) license for both yourself and the service account used by the flow, or that the report is located in a Premium capacity workspace (indicated by a diamond icon).Without Premium or PPU licensing, the export functionality will not operate.
If you have the necessary license:
Please refer to Microsoft’s official guide - Export paginated reports with Power Automate - Power BI | Microsoft Learn - to schedule the PDF export and save it to SharePoint.If you do not have Premium/PPU:
You may manually export the report from Power BI Service (File - Export to PDF) and upload it to SharePoint, or use Power BI Subscription emails as an interim solution for your team.
7 Replies
Hi swathrddy ,
Thanks for reaching out to Microsoft Fabric Community Forum.
Based on your description, you’ve created a one-page table report with scroll bars in Power BI and would like to automatically share it twice daily in a printable PDF format with your non-technical team by saving it to SharePoint. You've mentioned that your attempt to set this up using Power Automate was unsuccessful.To help you with this, I recommend following the step-by-step guidance in the official Microsoft documentation here:
Export paginated reports with Power Automate - Power BI | Microsoft LearnHi swathrddy ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Hi, I am still trying to figure out if its beacuse of the license.
Please refer this KBA,
The guides include prerequisites about licensing requirements, workspace capacity (Premium needed for paginated export), and admin settings.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export
