Power Pivot does not load new column added in Power query

Hi All,

I have a Power query connection only loading into power pivot. The model is source for many calculated columns and measures.

I have done one change in the source power query data by adding a new column.

Then I have copied the connection string from existing connections in Excel Worksheet and pasted in Power Pivot existing data connections strings so there is no problems in Data Refresh and it all works well.

But The new column I added in Power Query doesn't show up in Power Pivot.

I have tried to go in "Table Properties" and "Validate" the sql statement and also clicked "Design" to see if the sql statement inside is ok and then "Saved" there, but nothing seems to bring on the new column from power query.

I have the following statement inside "Table Properties":
SELECT * FROM [Booking details report]

What am I missing here ?

No my data sources don't come from any tables.

My power query fetches data from another excel sheet and the data in the external excel workbook also doesn't have any tables.

I just tried adding a new dummy row to the data to check if that is updating and yes its working fine. But the new column still doesn't refresh.

Is there an alternate way of telling power pivot to fetch all columns (instead of using " * " ) so that I can try to use the sql statements to try and manipulate to get this working.

Sorry, my issue is not with the source data.

Its in power query to power pivot.

I don't think you understood my issue well.

I will try to upload a sample file, I need to get rid of confidential data.

In the mean time to make it more easier to understand...

When I created the model in Power Pivot I had for e.g. 10 columns coming from Power Query.

Now I have 11 columns in Power Query including a new custom column.

When I refresh Power Pivot the updates I see only for the existing 10 columns I am unable to bring in the new Column from Power Query into Power Pivot.