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:

1. How to Auto-Schedule Data Export From Power BI 
2. Schedule data downloads / exports in Power BI 

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.