cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ctspradeep Regular Visitor
Regular Visitor

Export million of rows from power bi service to csv.

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 ?

3 REPLIES 3
Community Support Team
Community Support Team

Re: Export million of rows from power bi service to csv.

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

zoloturu
Advisor

Re: Export million of rows from power bi service to csv.

Hi @ctspradeep,

 

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)
ctspradeep Regular Visitor
Regular Visitor

Re: Export million of rows from power bi service to csv.

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