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

[yuanyangEnext]

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-an...

Is there a way to automatically Export data from PBI Desktop to Excel(CSV) With Script Like Power Shell?

[PBILover]

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]

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.

[v-xuding-msft]

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]

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

[PBILover]

Hi @yuanyangEnext and @v-xuding-msft 

Did you got answer to below Question?

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?

I am looking to achieve this.

Is there any way to do this?

[v-xuding-msft]

Hi @yuanyangEnext ,

Does that make sense? If so, kindly mark the helpful answer as a solution.  More people will find the answer easily and vote the idea up to get the feature fixed quickly.

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.

[v-xuding-msft · Accepted solution]

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.

[marc_frei]

The R Scripts is nice to export Power Query Tables. Is there a way to do this with a Visual (Dax Measures)?

A PowerAutomate flow needs to be triggered manually for my understanding.