Export million of rows from power bi service to csv.

[Anonymous]

Hi, I am unable to export million of rows from power bi service to csv. Is there any alternate option to to retrieve result set either through API call or workaround ?

[Andy_AI]

Hello this might be coming late but you can check out my article where I showed how to achieve this using DAX Studio.

https://urbizedge.com/using-dax-studio-to-export-over-1-million-rows-of-data-from-power-bi/

[zoloturu]

Hi @Anonymous,

Option 1:

1. Download .pbix file from Power BI Service.
2. Open it through Power BI Desktop.
3. Go to Advanced editor and copy Power Query (M) code from there.
4. Create and open new Excel 2016 file.
5. Paste it (result from #3) as source and connect to it.
6. Then you can load 1048576 rows per worksheet. But you still have an opportunity to divide it into several worksheets, for instance.

Option 2:

1. Create an Azure Analysis Services (AAS) instance based on your Power BI Report (see video from Microsoft how to do that - https://www.youtube.com/watch?v=wjOLp4E5K4Q&t=0s&list=LL9o8qEk9FiFg1ZvWHwGcxUA&index=6 )
2. Then you can connect to it from any application - Excel, Power BI Desktop/Service, SQL Server Management Studio. (Last one allows you to retrieve any amount of data from AAS, which you can export to CSV)

[Anonymous]

Thanks , I don’t have suscription to try in cloud.

[v-yuta-msft]

Hi ctspradeep,

The maximum number of rows that can be exported from Power BI Desktop and Power BI service to .csv is 30,000.

Please refer to: https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data#limitations-and-conside...

Regards,

Jimmy Tao