Selecting all columns from a Power BI table into table visual

[Anonymous]

Hi, 

I have a table in Power BI where daily new columns will get added or some of the old column might get removed. and i have created a table visual. so, suppose if a new column is added then i have to drag it into Values field of the table visual daily. I can not do this daily. 

Is there any way where table visual will be created regardless of how many and what columns are present and i dont need to drag/remove the column to a visual daily.

Thanks,

Shubham

[Anne1234]

I had the EXACT SAME challenge in Power BI, struggeling with it for days now. THANK YOU! 😃

[imocean]

Hi @Anonymous ,

Have you got this sorted? I'm facing the same challenge and couldn't see how the matrix visual can do that... Would really appreicate it if you can share how you've achieved it.

Thanks!

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may try Unpivot Columns in Query Editor and use a Matrix visual to display the data.

[PowerBIStarling]

I have tables loaded and I see them in the data portion of the visualization screen to the right. They are not pivot tables.  
How do I use unpivot to select all the columns as you have advised in your answer?
Please, use small words and talk to me like I am dumb, becasue I do not understand.

Thanks!

[imocean]

Hi @v-chuncz-msft ,

How do we use Matrix visual to include all columns in a table? I couldn't see where I can do that... 

Thanks
Harrison