Forum Discussion

willatkinson's avatar
willatkinson
Helper II
1 year ago
Solved

Connecting to sharepoint document sets

Hi,   I am trying to connect to sharepoint document sets to report on the metadata.   I can find the files in the documnet set through the sharepoint folder connector, but I can't see any of the ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi willatkinson ,
    Thanks again for your patience and all the detailed testing.Since you have already tried both the SharePoint Folder and List connectors and still can’t access the expected metadata for the files.At this stage, I’d recommend opening a Microsoft support ticket, so the team can take a closer look .
    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

    Hops this resolve your query.If so,give us kudos and consider accepting it as solution.

    Regards,
    Pallavi.

willatkinson's avatar
willatkinson
Helper II
1 year ago

Hi @v-pagayam-msft,

 

Thanks for your reponse, however, when I use the sharepoint online list connector, my document sets are not appearing with the other tables, do you know why this might be?

 

Thanks,

 

Will

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi willatkinson ,
Thank you for the follow-up.I would be happy to assist you!

Using the SharePoint Online List connector in Power BI Desktop by connecting to your SharePoint site URL and selecting the relevant document library. In Power Query Editor, look for columns like ContentType (which should show “Document Set” for your document sets) and FSObjType (where 1 indicates folders/document sets). You may filter by ContentType = "Document Set" or FSObjType = 1 to isolate document sets and see their metadata, including any custom columns like your “Test column.”

Hope this resolve your query.iIf so,consider accepting it as solution.

Regards,
Pallavi.

  • willatkinson's avatar
    willatkinson
    Helper II
    1 year ago

    Hi v-pagayam-msft,

     

    Thanks again for your help.

     

    When I connect to the correct library, all I can see is rows makring the folders in that library.

     

    I can only see these and I can not expand the folders, do you know why this is?

     

     

    Thanks,

     

    Will

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi  willatkinson ,
      Thanks again for the follow-up!I would be happy to assist you!

      As per my understanding,Document sets appear as single rows in the SharePoint Online List connector, but you might not expand them to see files inside. To access the files, use the SharePoint Folder connector. Since it doesn’t include metadata, you may combine both connectors in Power Query: one for the files, one for the metadata, and join them using the folder path. Let me know how it goes.

      Hope this resolve your issue.If so,give us kudos and consider accepting it as solution.