Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Connect Excel Files from SharePoint Folder with Different Document Structures

Hello - I am connecting my PowerBI to a SharePoint folder that is all excel files, however each excel file has different columns. Is there a way to pull all of the files at once? I had issues with it the first time as the files "combined" into the same structure. Is my only option to connect each file individually?

Need Help

3 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Anonymous ,

    Did you try Folder? 
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Nathaniel_C - I don't have this SharePoint drive networked to my desktop so im not able to access the folder via that approach. Any other thoughts?