Forum Discussion

Martin_Lanyon's avatar
Martin_Lanyon
Frequent Visitor
6 years ago

Exporting to Excel

I'm experiencing issues trying to export 149,000 records (below the 150,000 limit) from Power BI to excel.  Of the 149,000 records I'm getting only 4,600 records in the excel file.     I'm unable t...
Need Help
Tips and Tricks
Martin_Lanyon's avatar
Martin_Lanyon
Frequent Visitor
6 years ago

I'm trying to export the summarized data which has 13 columns.  There is a filter to limit the data to less than 150,000 lines.  The storage mode is Import.

 

The total data export would not be greater than 16-MB limit.

 

Any suggestions?

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Martin_Lanyon ,

 

The 16-MB only limited when use DirectQuery Mode, no worry to care about it if you using Import Mode.

 

We test with a simple sample, and we export 149krows(summarized, with 298k in raw) successfully, then we export 298k summarized rows, it only contain 150k.

 

 

What is the way you determine the row counts in table visual? please check the fields that set as "Do not summarized", the row number will less than the distinctcount of all those colums( such as the other value are blank, this row will not included), Have there any RLS rules applied when view the report?

 


By the way, PBIX file as attached.


Best regards,