Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Importing Sharepoint Library with Column Headings

I am trying to 'get data' from a sharepoint library, but I want to process the contents of the library itself, rather than data stored within and files in the library. I hope that makes sense...

 

The column headings of the sharepoint library are, say, 'file name', 'field x', 'field y', 'field z'. When I 'get data', the column headings of the imported data are 'content', 'file name', 'extension', date accessed', date modified', etc. - not of interest.

 

Does anyone know how to import the data fields associated with each file from the sharepoint library, rather than the metadata for each file?

 

Thanks!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    Please enter the URL which is like https://yoursharepointsite/_vti_bin/listdata.svc into Power BI Desktop via Get Data>OData Feed entry, then check if you get desired result for library.

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable

      For some reason it now says 'we couldn't authenticate with the credentials provided' when I try to log into my organisational account to access the data. This doesn't happen when I select 'Sharepoint Folder' as data source

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous,

        Do you use SharePoint Online or on-premises SharePoint? Could you please clear stored SharePoint credential by going to Files->Options and Settings-> Data Sources settings and try again?

        Regards,
        Lydia