Forum Discussion
Export data from All visuals at once
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!
Where do you write and run the script that trigger this functionality? 🙂
Im also trying to find a workaround for exporting Visuals data from my PBI reports.
My goal is to be able to export PBI reports Visual data on the server side, via an api request .
Basically I want to achieve the same functionality of the PBI embedded JavaScript SKD function here: https://github.com/microsoft/PowerBI-JavaScript/wiki/Export-Data
Limitation at the monument is that i can do this only on the client side, That mean that every time I want to export data from my visuals i must first render the report on the browser and only after the embedded report has been rendered, i can use the JS SDK visual.exportData() function . I'm trying to understand if there is any way to achieve this on the server side or as an automatic service that can run in PowerBi.
Thank you! 🙂