Skip to main content
Microsoft Idea

Power BI

Needs Votes

View underlying data - Display all columns

Vote (12) Share
Joe's profile image

Joe on 06 Apr 2017 19:19:52

On a Matrix visualization, we have the ability to export the underlying data to Excel. And that works. But it seems to display only some of the columns from the source table - not all.

From feedback on community forums, I was told "only columns which are used to create the visual can be exported on Power BI Desktop, while exporting data on Power BI service can export the columns which are used to create the visual together with all “Text” type columns."

That is very restrictive - can this be enhanced to allow "all" columns (regardless of data type) to be exported to a file when exporting underlying data from a visualization?

Comments (3)
Joe's profile image Profile Picture

Sivasankari Subbiah on 26 Mar 2021 12:55:59

RE: View underlying data - Display all columns

Does this issue still persists? I am still facing issue while downloading underlying data. Its not pulling all columns. Any help?

Joe's profile image Profile Picture

Gabriel Lainesse on 05 Jul 2020 23:24:16

RE: View underlying data - Display all columns

Agreed, it should behave like Pivot Tables in Excel.

Joe's profile image Profile Picture

Joe on 05 Jul 2020 22:45:40

RE: View underlying data - Display all columns

Similar to how Excel power pivots allow (upon double click on the numbers) all columns to be exported