Solved: export

Anonymous · ‎05-26-2022

I count the number of rows in Power Query and it's 4836 rows. Then I apply and close the power query and publish the report to PBI service. I then export the data both in xlsx and csv and I get 4212 rows. When I build a dashboard it's still 4836 count. Seems like it's only happening when I export data. I tried different ways but it's not exporting all rows. Does anyone face the same issue?

v-luwang-msft · ‎05-30-2022

Hi @Anonymous ，

Please try creating a new index column in Power Query and try exporting again.
I have encountered the same problem before and it was caused by duplicate columns.

refer:

https://community.powerbi.com/t5/Desktop/Can-not-export-full-data-of-table-very-small-dataset-couple/m-p/254896

Best Regards

Lucien

View solution in original post

v-luwang-msft · ‎05-30-2022

Hi @Anonymous ，

Please try creating a new index column in Power Query and try exporting again.
I have encountered the same problem before and it was caused by duplicate columns.

refer:

https://community.powerbi.com/t5/Desktop/Can-not-export-full-data-of-table-very-small-dataset-couple/m-p/254896

Best Regards

Lucien