SharePoint Online Folders and Documents

[SteveKWWHA]

Hi All

Apologies if this is in the wrong place but looking for some guidance

Essentially, i have been tasked with accessing our Document Library in Sharepoint Online, producing a list of all folders as well as the documents within those folders. Not sure if this is possible

Just started using powerBI but am able to connect to the sharepoint folder for the root site: https://xxxxxxxxxxx.sharepoint.com/sites/dynamics

What i then need is the next step which is https://xxxxxxxxx.sharepoint.com/sites/dynamics/Compliance/Forms/AllItems.aspx

This displays the list of folders and within each of these folders sits 1 or 2 documents. I've only just started using power BI and finding my way around it so any help or guidance would be great

Thanks

[trebgatte]

I have a blog post that should produce the desired results here: https://marqueeinsights.com/how-to-merge-multiple-excel-files-with-power-bi/

Also, check out our https://getstartedwithpowerbi.com resource page as there are a bunch of SharePoint related articles there as well.

Hope this helps!

--Treb, Power BI MVP