Forum Discussion
How to export data from a Power BI Desktop to Excel OR CSV With Power Shell
Hello Everyone,
I want to export data from Power BI Desktop model to Excel OR CSV files.
Following the link shown below, we can manually Copy (Ctrl+C）Data from Data View in Power BI Desktop and then Paste (Ctrl+V) it to Destination like Excel and save it as CSV file.
Is there a way to automatically Export data from PBI Desktop to Excel(CSV) With Script Like Power Shell?
Hi yuanyangEnext ,
I find a blog that introduces a way to implement scheduled export data with R script. Hope it can help you.
How to Auto-Schedule Data Export From Power BI
To make Power BI better, you could vote up the ideas to get the feature fixed quickly.
https://ideas.powerbi.com/forums/265200-power-bi?query=auto%20export%20excel%20csv
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
v-xuding-msftCommunity Support
Hi yuanyangEnext ,
You could try to use the third tool of DAX Studio to implement it. Please see the GIF.
Reference:
Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One Shot with DAX Studio
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your prompt reply and good advice. Is there any way to automatically Export data from PBI Desktop to Excel(CSV) By the DAX Studio tool's 「Export Data」 or schedule and can automate Excute it background without human. Best Regards, Yang Yuan
- v-xuding-msft
Hi yuanyangEnext ,
I find a blog that introduces a way to implement scheduled export data with R script. Hope it can help you.
How to Auto-Schedule Data Export From Power BI
To make Power BI better, you could vote up the ideas to get the feature fixed quickly.
https://ideas.powerbi.com/forums/265200-power-bi?query=auto%20export%20excel%20csv
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PBILoverHelper V
I think we can install the personal gateway to run the RScript on any VM and then auto-schedule the data set to refresh in power BI service, this way the data will be auto exported in an excel or CSV format.
- marc_frei
Helper I
thanks for your response. This is very clear to me. However with the R Script i can only export a Power Query Table to a csv but not values from a a Table (Visuals) with calculated DAX Measures e.g.
This works with PowerAutomate but just with a manual trigger.