Forum Discussion
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...
v-kelly-msft
Community Support
Community SupportHi 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
Kelly
Did I answer your question? Mark my post as a solution!
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.