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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-kelly-msft when you say you added new data? did you add new rows? I added new columns in the database view after unpivoting existing columns and when I refreshed, I didn't see the new columns. I'll check advanced editor and come back to you.

 

Thanks for your prompt reply. Truly appreciate it!

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