"Modified By" and "Created By" atrributes from SharePoint Library

[d_banduk]

I'm creating a dashboard that uses a SharePoint document library as a source. When getting the attributes for each file I don't get a "Created By" or "Modified By" attribute. Is there any way to do this?

[v-yuezhe-msft · Accepted solution]

Hi @d_banduk,

Do you connect to SharePoint Online Document Library? If that is the case, based on my test, when importing the URL which is like https://yoursharepointsite/_vti_bin/listdata.svc into Power BI Desktop via Get Data>OData Feed entry, I am able to get "Created","CreatedById", "Modified" and "ModifiedById" attributes. Do you want to get these attributes?


If so, please follow the above steps to connect to document library and check if you get the desired results. For more details, please review this blog. After connecting to SharePoint Online Document Library from Power BI Desktop, you are able to create report and publish it to Power BI Service and create dashboard.


Thanks,
Lydia Zhang

[d_banduk]

Thank you @v-yuezhe-msft,

This does get what I need. I must say it would be useful and a lot more user friendly if this was added to the 'SharePoint Folder' data connector.