Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Export data from All visuals at once

Hi all,   A client requested to have a csv export of the data for each visual in the report. The report has many visuals and it updates every 30min. I'm looking into a way to automate this export ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 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!

     

     

     

     

      

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

Glad to hear you make a solution that transform the DAX query of visual to the M query and use a R script to export the data, it sounds great, thank you for sharing it. 

 

We think currently the biggest problem seems some measure is difficult to transform into M query and please notice that when you reference another query in power query editor, it may query the source multi times, please refer to this documnet about it: 

 

Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the tip! will probably use dataflows then