Power Pivot Not Showing New Source Column

[legalhustler]

I created a new column ("Color") in my Excel data source, then used Power Query to transform the data and I am able to see and check the box to add the new column "Color" to the table...so far everything is good. My Power Query was already imported to the Power Pivot data model and when I "Refresh All" I don't see the new column "Color" in Power Pivot. What do I need to do?

When I clicked "Table Properties" in Power Pivot ribbon it says "The table was created in Power Query. To change this table, use Power Query instead." I don't understand what I need to do show the new column in Power Pivot data model.

 

[sandy666]

imho, re-create data model and pivot table after update power query table