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.
Yes 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.
Hi
When I follow these steps (in the last step instead of sharepoint folder, i created an email step to get the attachment in my mail) i was able to get the attachment to my email, but the wholedata is coming only in the first row, how to get that in seperate rows and columns as in my power bi dataset table visual.