New Column in my Source FIle

[Anonymous]

A new column has been added to my source file.  The column is located in the middle (not the end) of the file.  This column has valuable information that I need to pull into power query so that i can use it in my reporting.   I don't want to edit my source file prior to loading it.

Can you please help?

[Anonymous]

Yes @mussaenda, the issue is that the new column is not showing on my query.  This is an excel file that I manually refresh from a folder.

[mussaenda]

Hi @Anonymous ,

If you are getting your excel from a folder connector,

Double click the Expanded Transform File and select the new cloumn

[Anonymous]

Hi @Anonymous ,

You can refresh your data source in power query without reconnect.

Best Regards,

Stephen Tao

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

[Anonymous]

@ v-stephen-msft, when I refresh the new column is not included in my query

[mussaenda]

Hi @Anonymous ,

The issue is? It is not showing on your Query?

are you using folder or csv or excel to get the data?