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

Are you using a SQL script in the Advanced window of the SQL connector that limits the fields?  I don't do much with SQL beyond that so will be out of ideas if not.

 

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  Could you expalin to me how can I find out? 

I mean to find out I am  using a SQL script in the Advanced window of the SQL connector that limits the fields.

  • 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