Table export does not show all rows

[Anonymous]

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 table visual for just exporting. The number of rows is 45,000 and exporting as Excel. All the rows show in Data tab in desktop, and when exporting (desktop or online service), it only has about half the rows. I've tried changing table to matrix and all suggestions i can find.

any other ideas or other things to try?

[v-diye-msft]

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]

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]

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.

[amitchandak]

@Anonymous ,  Try analyze in excel and see if you get better results

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

[Anonymous]

@amitchandak  I've tried Analyze in Excel, however it shows all the raw data from the SQL in a pivot, instead of just the data in the table. The table is pulling from SQL server and shows 6 columns and the goal of the table is for the end user to click and export the data from the table in just a few clicks. if they use Analyze in Excel, i might as well pull the data in Excel and email it..

[Anonymous]

Did you tried checking 'Underlying data' instead of summarized data?

[Anonymous]

I tried using matrix and exported as underlying data and same results... there are 43,000 rows in the table (desktop Data tab) and if i try exporting from table or matrix, it returns only 19,000 rows.