New source column does not appear in Power Query

[campelliann]

Hi,

We have added a new column to our CSV file Source, which lives in sharepoint. The thing is that the new column is not appearing in Power Query.

1) I do not have the step "Remove other Columns".

2) I have cleaned the cache and refreshed the preview. Any ideas?

Thanks

[campelliann · Accepted solution]

Hi and thanks for the feedback. Refresh All was not working, I had to Change the Auxiliar Query "Transform File" and Sample file. Solved!

Basicaly I went to the Source of this auxiliary query, and runned again the "double arrows" to combine files. Then Power Query Created a new Transform File (1), and Sample File (1) which now included the new column. And then I changed the other queries with these new functions/parameters

[v-deddai1-msft]

Hi @campelliann ,

Based on my test, you should use refresh all ,the new added column  will show in power query.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai