We have a SharePoint library with 3 folders, each folder contains several more folders, and those in turn contain reports (word docs) that have to be completed and finalized.
We added columns so the person filling the report can mark it finalized and add the date finalized. My question is, is there any way to run a report on those columns to we can see which reports have been marked finalized. We would like it to be a single report for the entire library, instead of having results for each individual folder. I have tried PowerBI desktop and the Integrate>PowerBI options but I have not found a way to do this.
*the reason we have all those nested folders is because they are for each of our schools, and each school has reports for a number of students, so it is for organization as well as access control.