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
We had the same issue just now
We were simply loading the DQ SQL table without any PQ-level alterations; new columns added in SSMS/SQL table would not appear.
Fixed via forcing a table reload; added a sorting step in PQ -> table reloads in PBI -> Fields now appearing
Hope this helps