Forum Discussion
CSV extract from Power BI ( pro )
Hi ,
I want to create an extract from power bi , I have the necessary data by joining mutiple data sources , but not sure how to automate the "Export Data" option that we see in the BI dashboard . Appreciate your kind suggestion will be appreciated.
Regards,
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.
3 Replies
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
I am checking how this can be achieved.
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.
