Guidance re the drillthrough/excel export function

Hi. Sometimes it depends how the visualization is built. There are two ways of exporting, summarized data and underlying data. Those options can be changed in the report settings (inside PBI Desktop or directly from PBI Service). You can disable one export or both of them.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-underlying-data

Be sure that you have the underlying option there. If the data exported with underlying is still wrong, I would suggest building a different visualization (table), with the columns you need to export.

I hope that make sense

Hi AradhnaJugath ,

Please have a try.

Select File>>Option and Settings>>Options>>Current file>>Reprt settings>>Export data.

Select the option you need.

Please refer to the document for further information.

https://www.designmind.com/business-intelligence/export-underlying-data-in-power-bi/

 

 

Best Regards

Community Support Team _ polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.