Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Table export does not show all rows

I've seen several posts about an export from a table doesn't show all the rows. The posts explain about limitations, but no suggestions (that i can find) on why and how to fix.    My report has one...
Need Help
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

maybe this will help

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/#limitations-and-consi...

 

This document describes some considerations that you may take into account.

 

And also you have to consider, that the table automatically aggregates some data and basically suppresses rows that have no data.

 

For this reason you may have to tweak your table visualization a little

  • Show items with no data
  • Don't summarize the measure

Here is a very small example

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

ji v-diye-msft 

 

I've read thru limitations and the table doesn't have any. the columns do not have any blanks, less than the max rows for xlsx (43,000), no filters and no measures, aggregation turned off...I sent the pbix file to a team member who uses power bi a lot, and he can't see any reason why the table export visual is not exporting all 43,000 rows.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-diye-msft 

     

    I'm not sure what else to try or any alternatives? I've tried using a matrix and export underlying (desktop and online) and same results. This is a deal breaker for this Power BI report if the end user can't export the raw data and confident all records are exported.