New column in source view (SQL Server) not appearing in dataset after refresh?

[Anonymous]

I have done the refresh in the query editor.

Does anyone have any ideas?

Regards H-J-P

[v-shex-msft]

HI @Anonymous,

Power query will cache previous table structure into query steps, these cached structures not auto changes based on your source fields. You need to manually add these new fields in query steps formulas.

Model doesn't update when SQL table changes 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi Xiaoxin Sheng,

"You need to manually add these new fields in query steps formulas."

How exactly do I do that? Unfortunately, I'm not an expert yet. Thanks for the help.

Regards Heinz

[Anonymous]

I solved the problem using the Advanced Editor. Thanks Xiaoxin Sheng. 

Regards Heinz