List files in SharePoint folder and subfolders by using .Contents THEN .Files (or similar)

You can do that easily with recursive functions and SharePoint.Contents.  However, when you are done with that you will notice that it is not any faster than using SharePoint.Files.  Your choice.

What do you do next with the data you collected?  Does this even need Power BI or could this have been done via the SahrePoint batch API?

Thanks Ibendlin.

If there is no performance improvement to be had then I guess i'll just stick with filtering the files.

I then combine the contents of the files, performance some transformations and produce a series of reports in Power BI.