Forum Discussion

Frequent Visitor

6 years ago

Solved

Filtering Tables before Expanding

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 won...

Tips and Tricks

Tutorial Requests

v-frfei-msft
6 years ago
Hi alietzau ,

Please refer to this case.

https://social.technet.microsoft.com/Forums/en-US/12c8feb8-32d9-4c8c-aae6-53e2dd5aa57b/how-do-you-filter-a-nested-table-before-expanding-it?forum=powerquery

Anonymous

Not applicable

6 years ago

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.