How to get data ABOUT files, not data IN files, using Power BI. This includes normal documents but also SharePoint pages. You can pull any of your custom fields from the library, "likes" counts, path, created/modified-by user name, department, or title, and more!
The file path can be used to create a link directly to your files that open in a browser.
In this video, we go through what the output of the different SharePoint connectors look like vs OData and how to connect using OData.
The string you need to add onto the end of your SharePoint site url is:
_vti_bin/listdata.svc
0:00 Intro & use case
1:05 OData output
2:20 Expanding "people" data
3:30 SharePoint list v1 output
5:56 SharePoint list v2 output
7:39 How to connect with OData
9:49 Cleaning the data
11:15 Creating link to file paths
14:08 Using the link url in a table visual
