Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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
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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.