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.
Helper VI 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.
Helper Ithanks 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.