Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Logic Behind Underlying Data

I have asked before about the possibility of customizing what data is included in the underlying data export and I realize that this is not possible?  However, can someone explain to me the logic behind what data is included?  There are columns that are included that I definitely do not need, but then some columns which should be included but aren't.  Even if I have to deal with some unnecessary columns, I would like to know how to get these needed columns to be included.

Thanks in advance for your help.

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anonymous,

 



I have asked before about the possibility of customizing what data is included in the underlying data export and I realize that this is not possible?  However, can someone explain to me the logic behind what data is included?  There are columns that are included that I definitely do not need, but then some columns which should be included but aren't.  Even if I have to deal with some unnecessary columns, I would like to know how to get these needed columns to be included.

Thanks in advance for your help.


Your requirement is to add or delete some column when you export underly data from a visualization, right? I'm afraid this can't be achieved currently in power bi. For more details about the limitation, you may refer to: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-underlying-data-details.

 

Community Support Team _ Jimmy Tao

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

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@Anonymous,

 



I have asked before about the possibility of customizing what data is included in the underlying data export and I realize that this is not possible?  However, can someone explain to me the logic behind what data is included?  There are columns that are included that I definitely do not need, but then some columns which should be included but aren't.  Even if I have to deal with some unnecessary columns, I would like to know how to get these needed columns to be included.

Thanks in advance for your help.


Your requirement is to add or delete some column when you export underly data from a visualization, right? I'm afraid this can't be achieved currently in power bi. For more details about the limitation, you may refer to: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-underlying-data-details.

 

Community Support Team _ Jimmy Tao

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

Anonymous
Not applicable

Thank you, @v-yuta-msft.  That was helpful.  I think the best solution is simply to create a table that can be exported rather than relying on exporting underlying data.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.