Pull all the tables from multiple files of same format in an online folder

[Anonymous]

Hi,

I have 12 files, each file having monthly data from a year and all files have same format and multiple sheets of same name. Every sheet has a table in it.

These files are loaded in a sharepoint folder and I intend to pull all the tables from all the 12 files of that folder into a table in powerbi.

I tried using folder but it doesnt work. I tried using Web putting the url of the online folder and still doesnt work.

Please help !

[Anonymous]

Thanks all. It was all very helpful. I filtered based on required folder and combined the binary to get custom function. I created 12 tables with 12 custom functions. it gives me what i want. I only wonder if all the 12 tables could have been created using only 1 function.

Nonetheless, thanks a lot for your help.

[YalanWu_test]

Hi, @Anonymous ;

Such as KT_Bsmart2gethe said, you need connect sharepiont folder, and The Url is as follow:

copy this url then connect it.

SharePoint folder 

Best Regards,

[KT_Bsmart2gethe]

Hi @Anonymous ,

The right connector is:

Regards

KT