Forum Discussion
Solved
Data row count changes after export
Hi I have imported the data into power bi desktop. After import when i put the same data into table it and extracted the same. The row count reduces. When i count the rows using "countrow" the count ...
Then you can add an index column to your data and add it to the exported table. That should prevent the duplicates being removed.
Anyway using Power BI as an "Excel" exporter is not really what it's built to do.
If you really need to use the data in Excel, use Analyze in Excel instead.
mesuyog , if you are checking the number of rows vs row count measure, then you should sum up and check the row count measure after download, Most of visuals in power bi group the data by default. Means duplicate values(set of values) are not repeated
Thanks for the solution....but ...No i don't want to do any operations on the data just want to export as excel.....i have used COUNTROW just to crosscheck ...
