Forum Discussion
Error with Get Data from SharePoint Online document library - Expression.Error: The key didn't match
Found the solution. Thanks to Christopher Woodill for posting
From his post ...
If you want to connect to your document libraries (for example if you wanted to report on the number of documents being uploaded) you can do this through the OData feed instead.
The URL for the OData feed is: https://yoursharepointsite/_vti_bin/listdata.svc to bring up all the lists and document libraries in Power BI Desktop or if you want to connect to a specific list the URL will be: https://yoursharepointsite/_vti_bin/listdata.svc/ListName.
Once you have created a connection to your list or document library, you can use the table of items as a data source and create dashboards and reports based on this data.
Thank you for the response!
So, I was able to connect that way, but was showing ALL files. However, I figured out how to just pull the files from the document library I care about. So that's good.
The bad news is it is not pulling over the custom data fields we created for the document library where all the powerful information lives.
Found the solution. Thanks to Christopher Woodill for posting
From his post ...
If you want to connect to your document libraries (for example if you wanted to report on the number of documents being uploaded) you can do this through the OData feed instead.
The URL for the OData feed is: https://yoursharepointsite/_vti_bin/listdata.svc to bring up all the lists and document libraries in Power BI Desktop or if you want to connect to a specific list the URL will be: https://yoursharepointsite/_vti_bin/listdata.svc/ListName.
Once you have created a connection to your list or document library, you can use the table of items as a data source and create dashboards and reports based on this data.