Forum Discussion
Export data from All visuals at once
- Anonymous6 years ago
Thanks for the tips guys,
They seem all good workarounds and they led me to consider this option:
- I create new queries in PowerBI query editor, to match the queries outputted by the visuals (using GroupBy and calculations needed).
- I write a script in R to export them to .csv to a dedicated folder. At every scheduled refresh the R code runs and updates the files (that I name with each visuals' title) showing the latest data.
It seems to work for now, and it's fully automated. I'll keep you posted in case errors arise or performance goes down the drain using this method,
Thanks!
Hi Anonymous ,
Dax Studio can run the query of visual into a csv file but we did not find a way to run it automatically.
Or you can try to use the XMLA endpoint solution mentioned in this thread if you're on premium
Best regards,