Connect Excel Files from SharePoint Folder with Different Document Structures

[Anonymous]

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?

[Nathaniel_C]

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]

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?

[Nathaniel_C]

@Anonymous ,

Here is my go to person. @ImkeF 

Nathaniel