Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to add new columns from Onedrive / SharePoint folder to power query

Hi, 

 

I use a OneDrive folder as source for my data, there's added a new column in some of my CSV files but power query won't recognize the new column when I refresh the data.  

 

Tried to fix it by clicking the expand button of the content column but since the new column is not present in all of my CSV files, the new column won't appear in the 'Combine Files' widget. 

 

Any suggestions? 

 

Thanks! 

Need Help
Show and Tell

1 Reply

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous ;

      If you've connected to a file in SharePoint and got to the point where you have an identified file to expand to review content; it is this point in your code you should go back to.  Expand the 'Content' 'Binary' and it will reconnect to the file and hey presto it will pick up the additional column(s)..  

    New column from Onedrive / sharepoint not showing ... - Microsoft Power BI Community


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.