Forum Discussion
export data from power bi visuals to excel automatically
Hi Anonymous ,
You can create a Power Automate flow to export visual data automatically by clicking the flow button.
Please refer this viedo which introduces it step by step:
Power BI export to excel and csv with Power Automate
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i understand this exports to excel with a click of a button. i am interested in exporting automatically, i.e. setting it up so it is exported and saved every day at a given time without any human intervention. is there a way to do that?
Advocate IYes it can be done. I'm not well versed in this. I am doing this with a table. Not sure what other visuals it works with. I also think you need to be a dataset owner. These are the steps I take.
- Power automate scheduled flow (define your timing)
- PowerBI connector, run a query against a dataset. Identify your workspace and dataset. For the query, I'll explain below.
- Create CSV table. From = first table rows
- Current time
- SharePoint Create File. I name my file with currenttime.csv. File content is output
To get the query, I go to PowerBI Desktop > navigate to the page/visual > View > performance analyzer > start recording > refresh visuals > let it run > stop. Select your visual of interest and expand. Copy the dax code. This is what goes back into the query box in #2.