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.
Hi viswaaa
You can use PowerAutomate's automated cloud streaming, select the timer as the trigger, and then add the following actions:
1. Running PowerBI DAX Query
2. create csv file / excel file
3. create file on onedrive/spo
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Hi All,
I am doing in this way.
I created a paginated report using this and scheduled the paginated report using subscriptions and able to get the excel to my email
Please let me know your thoughts.
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.Hi viswaaa ,
Just checking in to see if you query is resolved.
Thanks for sharing the approach you followed. This works well for the requirement.
Also, thanks to others for sharing their inputs, which are in line with this approach.
If any further assistance is needed, please let us know.
