How to show dynamic columns in table ?

[kavyapriya]

so my query is i have one table with 4 columns but in future i will get few more columns so i need to show data in table if new columns  get add, i need to show new columns in table dynamically without manually add it into table.
 
for this we can do it with unpivot but i don't want to unpivot columns.

[ImkeF · Accepted solution]

Hi @kavyapriya ,
many connectors add new columns in the source automatically to the query in the query editor.
However, to my experience, this won't automatically be reflected in the data model with the next refresh.
Usually, you have to open the query editor, run the data preview there to see the new column, refresh the data and only then will new columns be added to the data model.

But there might be other experiences with it that I am not aware of.
 

[kavyapriya]

okay,
but if i have 2 tables one table is data and another table have data table column headers names so in this case is it possible to show dynamic columns without unpivot

Data Table:

Column Header Table:

[ImkeF]

Hi @kavyapriya ,
unpivot (other columns) is the way to go, as you cannot reference any of those "future" columns in the data model today anyway.

So what would be the benefit of loading additional columns that would not be used in the datamodel?