Missing columns in data view when click close & apply

[sparker95]

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 anywhere. They are not hidden in model view, don't appear in table view and then can't be searched for. I cant see anything in Power Query to stop them loading.

[sparker95 · Accepted solution]

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. 

[v-jianpeng-msft]

Thank you ！

Best regard

[Vanchy_Liao]

@sparker95 ,

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

[v-jianpeng-msft]

Hi, @sparker95 

You can try adding a blank column next to the column in Power query that is having problems, and then move back the two columns that you disappeared to see if that fixes the issue.
If you are using Excel, try converting it to xlsx format.

Solved: MIssing last column in Power Query - Microsoft Fabric Community

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sparker95]

Hi I'm using it within PowerBI. I tried this solution but it didnt work. 

[v-jianpeng-msft]

Hi, @sparker95 

Thank you very much for the description, can you describe what these two fields are in Power Query? Parameter? Or a column in a table? If it's a column in a table, what are their types? It would be of great help to me to judge it if I could provide some screenshots that don't contain sensitive information.

Best Regards

Jianpeng Li