Filtering Tables before Expanding

[alietzau]

I'm trying to pull folder permissions from Sharepoint using Power BI's Odata feed. The issue that I'm experiencing is that I have to unpackage all the embedded tables before filtering them. I was wondering if there's a way for me to filter the tables before I expand them so I'm not having to deal with so much data. Here is what the data looks like:

Folder Name	Permissions
FolderA	Table
FolderB	Table
FolderC	Table

PrincipalId	Member	Permission
4	Owners	Table
8	Members	Table
10	Visitors	Table

Name	Id
Full Control	4
Limited Access	8

I've tried to filter after expanding but my query has been running all night and this is not reasonable. I would like to expand these tables twice and I only want permissions that are not Limited Access. I don't want to expand these then filter because we're dealing with about 1000+ folders and it would just be too much to manage.

[watkinnc]

Hey there. Have you tried adding a custom column, =each Table.ColumnNames([DataColumnName])

Then you can filter the new column w/o expanding the tables until you need to.

[v-frfei-msft · Accepted solution]

Hi @alietzau ,

Please refer to this case.

https://social.technet.microsoft.com/Forums/en-US/12c8feb8-32d9-4c8c-aae6-53e2dd5aa57b/how-do-you-fi...