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  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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hello v-kelly-msft 

     

    this issue is not resolved. I added new columns in the database view and looked at DQ preview, I don't see the new columns. I don't have to unpivot these new columns and just have them show up normally. 

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

    Hi Anonymous ，

     

    I cant find the reason about your issue,but I believe it should be an individual phenomenon,so better create a support ticket via below link:

    https://powerbi.microsoft.com/en-us/support/

     

    Here is a reference.

     

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