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 ，

 

Have you clicked on "refresh" in report view or in query editor after you updated your data?

 

 

Based on my test,it works fine here,after I added new data to my database,then clicked "refresh",the data then was updated.

 

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

Hello v-kelly-msft 

 

Yes, I hit refresh and still didn't work. Was your test successful after unpivoting selected columns. I am guessing the new columns don't show up after transformations have been made.

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

    Hi Anonymous ,

     

    Yes,I followed your steps and unpivot some columns,then add new data in database, then refresh in desktop, after that,I create a table visual, and see the new data show up in the visual. But when I go to query editor,at the very start,I didnt  see the new data show up, so I refresh again ,and finally  it show up.

    I'm guessing whether there's an error in the connection with your data source,would you pls go to query editor>advanced editor to see whether there's an error?

     

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