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...
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
Kelly
Did I answer your question? Mark my post as a solution!
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?