Forum Discussion

sreejavg's avatar
sreejavg
Regular Visitor
7 years ago
Solved

Metadata from SharePoint document library

Hello,   How can we show the metadata associated with the files uploaded in a SharePoint document library in a Power BI report. While connecting to the Doc library from Power BI none of these fiels...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi sreejavg, 

     

    You can use OData feed connector in Power BI desktop then type below URL , choose Documents table:

    https://<yoursharepointsite>/_vti_bin/listdata.svc

     

     

    In Query Editor, you can expand CreatedBy and Modified By columns to see author and editor information. 

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
7 years ago

Hi sreejavg, 

 

You can use OData feed connector in Power BI desktop then type below URL , choose Documents table:

https://<yoursharepointsite>/_vti_bin/listdata.svc

 

 

In Query Editor, you can expand CreatedBy and Modified By columns to see author and editor information. 

 

 

Best Regards,
Qiuyun Yu 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello v-qiuyu-msft ,

 

In relation to the post - Metadata from SharePoint documetnt Library

 

This is what I am looking for, the only thing for me is that I have subsites, that I want to get the missing metadata from the libraries, is there away to connect to the subsite locations without having to enter each url address for each site, as I have around 100 sites.

 

I am trying to police missing metadata.

Any suggestions?

Thank you

Claire

  • Toto-Thanatorn's avatar
    Toto-Thanatorn
    New Member
    1 year ago

    Hi,

    I have the same issue, did you manage to find out the way to do it or a workaround?