CSV extract from Power BI ( pro )

[abhijitroy99]

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,

[Greg_Deckler · Accepted solution]

@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

[v-yingjl · Accepted solution]

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.

[Greg_Deckler · Accepted solution]

@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

[abhijitroy99]

I am checking how this can be achieved.