Forum Discussion
schedule excel export
Hi viswaaa ,
This is actually a clever solution (to me atleast). You can maintain the formatting in Excel as well in this way.
If you want to hook the paginated report up in a Power Automate flow to automate the saving to OneDrive part, even then there is an easy step available to do it since paginated reports export to excel without a fuss. From my experience, paginated reports have a tendency of introducing small additional cells in Excel around edges (or new pages in pdf) when the placement is not done right in the report builder but with some care this is not really an issue.
You have two main options to achieve this.
Option 1 – Paginated Report
Create a Paginated Report for the table and use its subscription feature to export the data to Excel and deliver it to OneDrive or SharePoint. This is the most robust and natively supported option.
Option 2 – Power Automate
Use Power Automate to export the visual data:
Get the DAX query from Performance Analyzer
Create a Power Automate flow
Trigger: Manual or Power BI data-driven alert
Action: Export to file for Power BI reports
Format: Excel (.xlsx)
Select the report and the single visual or page
Action: Create file
Destination: OneDrive for Business or SharePoint
Both approaches work; Paginated Reports are better for scheduled, pixel-perfect exports, while Power Automate is best for automation and flexibility.