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

[Anonymous]

Unfortunately, you're a little out of luck.  There is no way for a query to generate a variable amount of tables.  One query = 1 table.  There's no way to say "there are 5 tables with data, so generate 5 new queries that each pull a separate table out of this filtered result set.

May I ask why this is needed?  Shouldn't your data model be based on a finite set of tables?  Why should the number of tables that you import into the data model change without your conscious involvement?

[excelmjr]

Thanks @Anonymous. I am importing tables out of Dynamics AX. There are over 6K tables loaded. But only 2K are being used in our environment. 

I was noticing that when I import data it creates a new query for each table selected. So I was hoping to use the system logic to limit the names of the tables to pull in before it created the queries. 

Plus, when I do pull in all of the queries it crashes because some of the tables have data that the system does not like. 

Thanks for the input. 

Just have to keep searching.