Importing Sharepoint Library with Column Headings

[Anonymous]

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!

[v-yuezhe-msft]

@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]

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

[v-yuezhe-msft]

@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