Forum Discussion
export
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?
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:
Best Regards
Lucien
1 Reply
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:
Best Regards
Lucien