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.https://www.biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax-studio-methodsIs 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.

How to export data from a Power BI Desktop to Excel OR CSV With Power Shell

8 Replies

v-xuding-msft
Community Support
6 years ago
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.
- yuanyangEnext
  New Member
  6 years ago
  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
    Community Support
    6 years ago
    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.
PBILover
Helper V
4 years ago
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
  4 years ago
  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.