List all files for each SharePoint site under a domain

[jbaisley]

Hello folks,

Aspecific question. I am trying to get a list of all files for each sub site under a master domain. Ideally I would want to extract paths, and meta data such as creator, date created, modified, etc. But then jsut the file name. We use our SP for managing clients, so each client has a sub site and each subsite will have one or more project folders. We want to be able to see if they comly to a given file stuctuer so we need to listen to everything.

I have tried this Power BI tutoiral to get all site names. It was very helpful and I toyed dwith using the column of site names to be a recursive search but I am unsure how.

https://youtu.be/qYhXdNDnyfI?feature=shared

Second was this answetr, but it wasn't for this exact problem as its manual.

Get a list of Files in document libraries across all site collections - Microsoft Community

Thridly I tried this but is also doens't answer the question. 

Combining Excel Files hosted on a SharePoint folder with Power BI | Microsoft Power BI Blog | Micros...

I don't need to open any files or combine. I just need to scrap a list from my entire tenant to see what's available.

[christinepayton]

I think Jordan, who was the one who got me started on that first video, has a PBIX that gets the file info. He gave me permission to put his LinkedIn profile in the video description, you might try pinging him with that and seeing if he'll send you a copy? I've been meaning to make more in that series but my list of things I want to do is very long lol. 😅

[jbaisley]

Thanks Christine! Your solution was excellent! It got me most of the way. I will message Jordan 👍

[Anonymous]

HI @jbaisley,

AFAIK, current only the folder connector support the looping operation to enum each folder and its subfolder contents.

For power bi SharePoint connector, different level sites required verify different permissions. You can't direct use single permission to access and operation and enum each site.

Perhaps you can consider to python script as data source with for function to looping on the SPWebCollection to get detail contents:

Run Python scripts in Power BI Desktop - Power BI | Microsoft Learn

SPWebCollection Members (Microsoft.SharePoint) | Microsoft Learn

Regards,

Xiaoxin Sheng