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
dufoq3's avatar
dufoq3
Community Champion
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