Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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

I have done the refresh in the query editor.

Does anyone have any ideas?

Regards H-J-P

Anonymous
6 years ago
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

3 Replies

Anonymous
Not applicable
6 years ago
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
  Not applicable
  6 years ago
  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
    Not applicable
    6 years ago
    I solved the problem using the Advanced Editor. Thanks Xiaoxin Sheng.
    
    Regards Heinz

Related content