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.
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 - including Author and Editor is available in the Power BI. How can we pull these information to report?
Thanks in advance,
Sreeja
Solved! Go to Solution.
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
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
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
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.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |