Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AILearn2008
New Member

Using SharePoint Document Library Metadata

Instead of creating folders within a document library, I want to utilize Metadata. When I load the Document Library in Power Query, the metadata fields aren't showing and this is forcing me to create subfolders which I was hoping to avoid. 

 

Any tips or tricks for using metadata?

2 REPLIES 2
christinepayton
Super User
Super User

You can connect to it using the SP List connector or OData connector instead, which has all the metadata, then join it to the file contents (if you need the file contents). The list connector does work with libraries, they're essentially very similar architecturally - it's just that their "item" is a file instead of a data row. 

OwenAuger
Super User
Super User

Hi @AILearn2008 

If you are connecting to a SharePoint Online Folder (using SharePoint.Contents or SharePoint.Files) and want to include additional columns from the Document Library, I answered a similar question recently here:

https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-a-SharePoint-folder/m-p/4149036#M1...

 

I used OData.Feed to access the additional columns and joined with the SharePoint.Contents query.

 

Is this the sort of thing you're wanting to do?


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors