Exporting Underlying Data

[phewison1]

Hi, I have a data set with 2,605 rows. When I export the data, I am getting 2580 rows. I've noticed that in the export, there is a column that seems to be counting the number of duplicate records. I need to keep the duplicate records. How do I stop it from doing this?

[Pragati11 · Accepted solution]

Hi @phewison1 ,

Go to Power Query editor in Power BI and add an INDEX column to your data.

Save your changes.

Now move this INDEX column (un-summarised) in the visual from which you are exporting the data.

If you export the data now, you will get all the rows.

Thanks,

Pragati

[Anonymous · Accepted solution]

Hi @phewison1,

Which type of export feature are you worked on? If you are work on the desktop side, you can refer to Pragati11 's suggestion to add some unique value to keep all records.
If you are work on the service side, you can export with the 'underlying data' mode to keeping all records.

Export data from a Power BI visualization - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng

[Pragati11 · Accepted solution]

Hi @phewison1 ,

Go to Power Query editor in Power BI and add an INDEX column to your data.

Save your changes.

Now move this INDEX column (un-summarised) in the visual from which you are exporting the data.

If you export the data now, you will get all the rows.

Thanks,

Pragati