connect to sharepoint folder or onedrive folder with subfolders

Many thanks for your reply, Qiuyun Yu

I was able to connect to the folder on SharePoint in a roundabout way. Pointing directly to the folder did not work. here 

1.  connected to the entire site   = SharePoint.Files("https://perkinswillinc.sharepoint.com/", [ApiVersion = 15]) 
2.  filtered rows to only look in my folder = = Table.SelectRows(Source, each Text.Contains([Folder Path], "https://perkinswillinc.sharepoint.com/Shared Documents/DigitalPractice/BIMLISt_Reports/"))

the problem now is that I am getting error processing the files, I am using a function which gives me an error

the problem now is that I am getting error processing the files, I am using a function which gives me an error

here is a function

 = (path as text) =>
let
Source = Xml.Tables(File.Contents(path)),
Table0 = Source{0}[Table],
#"Changed Type" = Table.TransformColumnTypes(Table0,{{"ID", type text}, {"SchemaVersion", Int64.Type}, {"Name", type text}, {"LastUpdatedDate", type datetime}, {"IsRemote", type logical}, {"RemoteServerAddress", type text}, {"IsCloud", type logical}})
in
#"Changed Type"

When I try to invoke this function on https://perkinswillinc.sharepoint.com/Shared Documents/DigitalPractice/BIMLISt_Reports/4298b4aa-3dcb-4c34-afaa-4d556bb2b3a9/bimlist.bldb as a path, i get an error

apparently it does not take the sharepoint path :(

any insight will be much appreciated

thanks again for your help