RBR Reports File Export Using Power Automate to OneDrive or SharePoint
In this article, we’ll explore how to export Report Builder Reports to One Drive or SharePoint using Power Automate.
To implement that, follow the steps below.
Step 1:
Sign into Power Automate flow.microsoft.com
Step 2:
Select Templates, and search for paginated reports.
Step 3:
Select “Save a Power BI paginated report to OneDrive for Business” or “Save a Power BI paginated report to a SharePoint Online folder”. Make sure you’re signed into Power BI and OneDrive for Business or SharePoint.
Step 4:
Select Continue.
Step 5:
To set the Recurrence for your flow, select an option in Frequency and enter a desired Interval value.
Step 6:
In the Workspace box, select a workspace.
Step 7:
In the Report box, select the paginated report in the selected workspace you wish to export.
Step 8:
In the Export Format box, select the desired export format. Optionally, you can specify parameters for the paginated report. Find detailed descriptions of the parameters in the connector reference for the Power BI REST API.
Step 9:
In Folder Path, select the OneDrive for Business or SharePoint folder where you want to export your paginated report.
Conclusion
1. Power Automate automatically generates a File Name and File Content for you. You can change the file name but keep the dynamically generated File Content value.
2. When you’re done, select Next step or save. Power Automate creates and evaluates the flow, and lets you know if it finds errors.
3. If there are errors, select Edit flow to fix them. Otherwise, select the Back arrow to view the flow details and run the new flow.
4. When you run the flow, Power Automate exports a paginated report in the specified format to OneDrive for Business or SharePoint Online.
About Us
Bi3 has been recognized for being one of the fastest-growing companies in Australia. Our team has delivered substantial and complex projects for some of the largest organizations around the globe and we’re quickly building a brand that is well known for superior delivery.
Website:https://bi3technologies.com/
Follow us on,
LinkedIn: https://www.linkedin.com/company/bi3technologies
Instagram: https://www.instagram.com/bi3technologies/
Twitter: https://twitter.com/Bi3Technologies
