Only import SQ tables with data into individual queries

[excelmjr]

I have queried a database. I have used the Table.IsEmpty in a if statement. Thus restricting my data pull to only tables that actually contain data. (Also, if a new table is used it will show up on the next refresh). My question is, how do I tell Power BI to import each table as a separate query?  I do NOT want them all merged together.

let
Source = Sql.Database("server", "database", [CreateNavigationProperties=false]),
#"Added Custom" = Table.AddColumn(Source, "Custom", each if Table.IsEmpty([Data]) then "Empty" else "Has Data"),
#"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Custom] = "Has Data")),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Custom", "Kind"})
in
#"Removed Columns"

I appreciate any suggestions

[v-shex-msft]

Hi @excelmjr,

>>My question is, how do I tell Power BI to import each table as a separate query?

Nope, current power query not contains these features, I think you need to manual add them to new queries.

Regards,

Xiaoxin Sheng