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
2 years ago

I am facing the same issue. I updated tablequery in database that returns one additional column but that column didn't appear in powerBI refresh. How can I resolve it?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I came across this issue today and a search led me to this thread. I tried to delete my view and add it back. But frequent changes frustrated me leading again to do some trial and error. Here is what worked for me.

1. Select the table/view from Fields Panel, Right click on it

2. Select Edit Query which will take you to Power Query Editor 

3. Select the Home->Manage Columns->Choose Columns drop down and select Choose Columns

4. Just unselect any random column from the list and click Home->Apply & Close->Apply

5. This will show the all the columns now excluding the one unselected in Step 4

6. Repeat Step 3 and select all columns you need and repeat Step 4

 

Hope it works for you, it did for me. This obviously a bug in Power BI.

 

Thanks,

Lachhaman