Forum Discussion

pfbrp's avatar
pfbrp
Frequent Visitor
1 year ago
Solved

Table.SelectRows on Sql.Database

The Soruce is an Sql.Database() returning a table of tables accessible through the [ Data ] column. Some of those tables return data, but some are either empty or denying access. I want to have a p...
Need Help
  • dufoq3's avatar
    dufoq3
    1 year ago

    Hi pfbrp, check this:

     

    Before

     

    After

    let
    Source = #table({"Data"}, {{null}, {#table(null, {})}, {error "Just test ERROR"}, {#table(null, {{1,2,3}})}, {"abc"}, {100} } ),
    FlteredTables = Table.SelectRows(Source, each (try [Data] otherwise false) is table)
in
    FlteredTables
Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi pfbrp  you could try simplifying the query and try this please as your query is evaluating the whole table on try....otherwise 
Table.SelectRows(
Source,
each
try Value.Is([Data]{0}, type table) otherwise false
)
If this post helped please do give a kudos and accept this as a solution 
Thanks In Advance

  • pfbrp's avatar
    pfbrp
    Frequent Visitor
    1 year ago

    With small correction (testing for record instead of table):

    I state that the effect is the same.

    Did you mean that a whole table is evaluated at each Table.SelectRows() iteration? Why would it be if I'm checking on the first row only?