Connecting to SharePoint Online Document Libraries from Power BI

The new Power BI Desktop has a data source specifically for SharePoint Lists. 

image

This works quite well but doesn’t currently support document libraries (even though they are also SharePoint lists).   If you connect to your SharePoint Online site you’ll find that the document libraries are not available through the SharePoint List data source, only lists.

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.

  • Troy Tinsley

    Christopher! You are now my best friend! Thanks so much for posting this!

  • José Martínez

    Hello Christopher!

    I tried you recommendation, however when data start loading, I get this Error:

    Details: “We couldn’t parse OData response result. Error: An error was read from the payload. See the ‘Error’ property for more details.”
    Have you come across with this issue? I thought it was related to an specific field within the Library, but even if I try to select just a few fields (like Title, Date) I am still getting the error.
    Any advise? Thanks so much !!

  • Caitlin Knox

    I was able to make the connection, but it shows as an item would if I would have connected to a list. How do I extract the excel file in the Document library? Eventually, more will be added which would need to be combined