New colums from source Query won't populate

[cmajka]

Hi All -

I have created several new columns in my source query, which is getting pulled into Power Query. After a refresh, I can see the new fields in PQ, however, I cannot get them to populate in the data model/PowerPivot...or my field list for the pivot table. Any suggestions?

Thanks!

 

[Matt Allington]

Wat. Erosion of Excel are you using? If 2010, you need to reload the query from scratch

 

[cmajka]

Hi Matt -

I am using Excel 2016 for this project. If I try to update the table in Power Pivot using the Table Properties, it says that I must use Power Query to update it...however, Power Query appears to show the new columns so it seems like a proverbial "endless loop"...

Thanks

 

[Matt Allington]

strange. I have never seen this before.