Fetching all the views under a schema, loop through it to apply filtering

[vinodpbabu]

Hi,

I am trying to fetch all the views under a schema in a database and need to loop through it to apply filtering based on tenantid  and build a navigation table with the result. 

I have added the code block which i used to loop through the views under PowerBi Scehma. I need to apply a filtering based on tenantid on these views.

Database = OdbcDataSource{[Name = database]}[Data],

        PowerBiTables = Database{[Name = "PowerBi"]}[Data],

        FilteredTables = Table.SelectRows(PowerBiTables, each [Name] <> ""),

Can we do something like this

FilteredTables = Table.SelectRows(
Table.SelectRows(PowerBiTables, each [Name] <> ""),
each [TenantId] = tenantId
),

I am new to this and any help will be apprecieated.