Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

New Column in my Source FIle

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?

Need Help

5 Replies

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous ,

     

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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Hi Anonymous ,

       

      If you are getting your excel from a folder connector,

      Double click the Expanded Transform File and select the new cloumn