Forum Discussion
Power BI Live data, automated schedule export data to CSV
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.
4 Replies
- amitchandak
Super User
weiyann83 , You can check power Automate or Power bi REST API for same. If those can help
- weiyann83Frequent Visitor
power automate is not free right?
- amitchandak
Super User
weiyann83 , Yes. I think it is not free.
- AnonymousNot applicable
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.
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