Forum Discussion
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.
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.
Hi t_horrocks
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.