Export to Excel using Power Automate

[BipinYadavwell]

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.

[v-xiaoyan-msft]

Hi @BipinYadavwell ,

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

[aj1973 · Accepted solution]

Hi @BipinYadavwell 

Please watch this video, is very helpful

How to Export Power BI Data to Excel | Query against a dataset (youtube.com)