Forum Discussion
CSV extract from Power BI ( pro )
abhijitroy99 If you want to automate, check out the Power BI REST API. Reports - Export To File (Power BI Power BI REST APIs) | Microsoft Docs
Hi abhijitroy99 ,
Currently you could not export data automatically from power bi dashboard directly.
You can try to run R script for your dataset and set scheduled refresh for it to export data automatically.
write.csv(dataset, file = "C:/dataset.csv")Note:
- To enable a scheduled refresh of R scripts, the On-premises data gateway (personal mode) has to be used.
For more details, you can refer this article and video which introduce it in details:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi abhijitroy99 ,
Currently you could not export data automatically from power bi dashboard directly.
You can try to run R script for your dataset and set scheduled refresh for it to export data automatically.
write.csv(dataset, file = "C:/dataset.csv")
Note:
- To enable a scheduled refresh of R scripts, the On-premises data gateway (personal mode) has to be used.
For more details, you can refer this article and video which introduce it in details:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.