Forum Discussion
Sharing the report
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.
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 Learn
Hi 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.
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.Hi swathrddy
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions
Hi swathrddy ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
