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 ,
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