Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Added Columns not found in the Query

Hallo Everyone, I have SQL DB I have created 4 new Columns in a data table. However I can not find these new Columns when I go to Edit query.    Is there a way a round that? somehow to include th...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    If you added the column in SQL DB, when you refresh the datasource in desktop, it should be displaying as normal.

    Here's similar post could be your reference:

    https://community.powerbi.com/t5/Desktop/Column-not-showing/td-p/374480 

     

    If you added the calculated column in model view, please note that any column that you "Add" ( as a formula) , does not appear in "Edit Query"

     

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

If you added the column in SQL DB, when you refresh the datasource in desktop, it should be displaying as normal.

Here's similar post could be your reference:

https://community.powerbi.com/t5/Desktop/Column-not-showing/td-p/374480 

 

If you added the calculated column in model view, please note that any column that you "Add" ( as a formula) , does not appear in "Edit Query"