Forum Discussion
How to export data from a Power BI Desktop to Excel OR CSV With 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.
Community SupportHi 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.
- marc_frei
Helper I
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.
- 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.
PBILoverHelper V
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?