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"

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

You would have added that SQL script, so that is probably not it.  If you click on the gear icon for the Source step and then expand the Advanced Options window.

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mahoneypat  no nothing was added to edited there.