Forum Discussion

phewison1's avatar
phewison1
New Member
5 years ago
Solved

Exporting Underlying Data

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 Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    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's avatar
    Anonymous
    5 years ago

    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's avatar
Pragati11
Super User
5 years ago

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