Extract large dataset from Power BI to csv/excel

[Anonymous]

Hi,

I have been looking for solutions to automate extraction of Power BI dataset which has more than 100k rows into a csv/excel file. The closest I could get is to use a loop in power automate --> filter data based on row index column (present in the dataset) --> append them to an array --> finally to a csv. However, my problem is that I do not have an index column in my dataset, nor do I want to modify my dataset. Can anyone suggest if there is way to extract data out of BI using power automate?

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can refer the following video to get it:

Export from Power BI to Excel up to 🔥100k rows 🔥| Run a query against a dataset

In addition, please review the following links and check if their solutions(by DAX Studio) can be used as an workaround...

Exporting a large number of rows from Power BI to Excel or CSV

Exporting through DAX Studio (a free community-tool) is very fast and you can even export your whole model at once: https://xxlbi.com/blog/dax-studio-export-all-data/ 

---

Export million rows table from Power BI overcome the limit of 150k rows

Best Regards