Import multiple files located in SharePoint

Kane · ‎03-22-2016

Hi, Power BI experts,

Suppose I have hundreds of excel files located in my SharePoint.
And I have a list of the links of the files, such as

https://mycompany.sharepoint.com/teams/my_team/file1.xlsx
https://mycompany.sharepoint.com/teams/my_team/file2.xlsx
https://mycompany.sharepoint.com/teams/my_team/file3.xlsx
...
https://mycompany.sharepoint.com/teams/my_team/file500.xlsx

Is there any method by which I can import all the files to my PowerBI Desktop with few clicks/operations ?
You know, nobody want to import hundreds of files one by one.

Best Regards,
Kane

ImkeF · ‎03-22-2016

From Folder should also work here: Get Data -> New Source -> More -> Folder

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Helpful resources