Forum Discussion
Export to Excel using Power Automate
I have created Export to excel button using Power Automate which saves files to one drive of users. But it only saves empty excel file, its not grabing data from the report. i need help with this.
Hi Anonymous
Please watch this video, is very helpful
How to Export Power BI Data to Excel | Query against a dataset (youtube.com)
2 Replies
Hi Anonymous
Please watch this video, is very helpful
How to Export Power BI Data to Excel | Query against a dataset (youtube.com)
Hi Anonymous ,
Make sure that your flow in Power Automate is correctly set up to pull data from your report and write it to the Excel file. and ensure that Power Automate has the necessary permissions to access your data source and that the connection is working properly.
The Excel file needs to be set up correctly to receive data. This includes having a table for your exported data to be inserted into.
For detailed steps,you may refer to：
Solved: Automate Export to Excel (e.g. store in OneDrive) - Power Platform Community (microsoft.com)
Best regards.
Community Support Team_Caitlyn