Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

New column added in database now showing in PowerBI direct Query?

Hi All,    I am using PoweBI directQuery mode and have connected to couple of tables using Snowflake datasource. I have created another column in Snowflake view but that is not showing up in my exi...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Open the power query and refresh the data there. Also, check there is no step to remove "Other columns". If yes, then fix that step

     

    Once you see in power query, close and apply and refresh

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Open the power query and refresh the data there. Also, check there is no step to remove "Other columns". If yes, then fix that step

 

Once you see in power query, close and apply and refresh

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak   When I open the query editor, it shows ther but not in the model page. You see CREATED_DAY is there in the query editor mode but when I close it and go to Model page to create relationship , it is not showing there. I already checked all the fields till the end (showing you the screenshot which start with CRE....).

    .  

     

    Also, I just tried to get the same view in the same workbook, and it is showing in new Get Data through but not the old one. see the screenshot below -