Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ,

 

Yes, I added new rows,just now I tested to add new columns and return an error as below:

 

 

Does any error show there?

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!
 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-kelly-msft  this error is because the columns must have the same scale and precision before you unpivot. Once you set that, this error will go away. My error is after you unpivot existing columns and then add new columns to the direct connection.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi Anonymous ，

     

    Go to "edit queries">click on "advanced editor" ,to see whether the new column has been written inside:

    Here I added new column,calling "Syear",at first it wasnt inside and returned an error,then I added it inside,now it works fine,as you see below:

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-kelly-msft I'll add to Advanced Editor and come back to you.

       

      thanks

      saujanya

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        6 years ago

        Hi  Anonymous ,

         

        Is the issue solved?

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!
         
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-kelly-msft I'm going to add new columns today and I've completed making my charts and a little concerned the new columns might not show up. I will check advanced editor and come back to you. However, adding lots of fields manually is a pain. It has to be simplier than this right?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello v-kelly-msft , Kelly 

       

      I don't want to add the new columns to the existing unpivioted columns and just show them as new columns. So in your example, you unpivoted the columns in PowerBI, added new columns to the database, and updated the unpivoted list. Did the new columns show up as is after refresh?