M except errors

[Analitika]

i need filter all tables wich is empty

= Table.SelectRows(Source, each (not Table.IsEmpty([Data]) ))

but it stop with error

DataSource.Error: Sybase SQL Anywhere: Unable to connect to server '': [Sybase][ODBC Driver][SQL Anywhere]Unable to connect, server definition is circular

but without not it work perfect

= Table.SelectRows(Source, each ( Table.IsEmpty([Data]) ))

So have to show not empty tables only?

[mahoneypat · Accepted solution]

If you have a table of tables, you could add a custom column with = Table.RowCount([TableColumn]), and then filter that new column for >0.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat