Document Set / Power Bi

[Anonymous]

Hi everyone,

I have a question about creating PowerBi reports from Sharepoint.

Our files are organized as DocumentSets in Sharepoint. I would like to create reports reflecting the metadata of the document set, but PowerBi also reflects the data of each document composing the DocumentSet. Is there a way to filter this, so we only get the data of the set, but not all documents?

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

You can use 'SharePoint folder' connector to import the data and transform the data in 'Edit Query'.

Step1, Delete the useless columns.

Step2, Get the data of the file in 'Document'.

Step3, Delete files you don't want.

SharePoint Folder 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattAllington]

I haven't done it, but I don't see why not. When connecting to regular folders, you can load the folder metadata, not the docs. I don't see why it would be any different with document sets.