Power BI Live data, automated schedule export data to CSV

[weiyann83]

Need help from power bi expert, how can we achieve if we want power bi automated export the table data to CSV (below highlighted)? I able to achieve this using import data but not live data due to live data cannot use transform data feature.

[Anonymous]

Hi  @weiyann83 ,

Here is a blog that introduces a way to use R scripts to plan to export data.

https://sqlitybi.com/auto-schedule-data-export-from-power-bi/

Also use Dax studio to export data from Power BI Desktop to CSV.

https://www.biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-an...

https://www.biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-2-importing-pow...

Hope it helps you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@weiyann83 , You can check power Automate or Power bi REST API for same.  If those can help

[weiyann83]

power automate is not free right?

[amitchandak]

@weiyann83 , Yes. I think it is not free.