Forum Discussion
Completeness of a product dossier (based on SharePoint)
Hi all, I have received this interesting question from one of our customers. They have a Microsoft 365 subscription that includes Microsoft 365 Business Premium and Power BI Pro. They are activel...
IMO your best bet here is to use Power BI; the OData connector is quite good at pulling file metadata. This would involve some DAX, so you'd need to dig into how that works a bit, but it would be totally feasible to do this with the tool, assuming that the files are reasonably consolidated (e.g. in a single library or a few libraries, not spread across 100+ sites). I have a video on how to use the OData connector to access file information here: https://youtu.be/yeIQ9jKln_I