Forum Discussion
New Columns added not showing up in Direct Query Connection
I've used a direct query connection to build some charts and I have unpivoted a few columns. However, after new columns were added to the database view, I can't see them. I am not sure what I'm missi...
Found a solution for this problem, for other reader clarification, this is related to connecting to a semantic model from another pbix with direct query. You will not see any queries under Edit Query or Advanced Editor as this is not direct query to a query only, the entire data model comes from semantic model.
What i did was open Data Source Setting under Transform Data, click "Change source", re-select the semantic model again (the similar one) then wait the pop up box to load (Do not re-select any tables here otherwise it will be duplicated) and just click submit. The newly added fields/column will appear.
works perfectly, thanks