Forum Discussion
Solved
Missing columns in data view when click close & apply
I've got quite a big model and recently I've had two fields dissapear off it that are quite crucial. I can see these fields when in Power Query but as soon as I click close & load they dont appear an...
Hi both, thanks for offering help. I've managed to resolve this, the model had automatically renamed the field to align it with what I have in the dataverse, so it doesnt now match what I have in Power Query. It was difficult to find as I have many columns in that table, but saw someone had experience similar in another thread.
i assume that you clicked the "Close & Apply" button and PBI didn't trigger "Refresh" event.
if i add a column to my data source, i will:
1. Enter into Power Query -> Refresh Preview -> Check the column
2. Click "Close & Apply" button -> Click "Refresh" button