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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi pfbrp,

Thanks for reaching out to the Microsoft fabric community forum.

 

It looks like you are trying to filter out tables that are empty or inaccessible. As dufoq3 and Akash_Varuna both gave responses of their own for your query, can you please confirm if you were able to solve your issue with the help of their responses. If yes, then please mark the helpful response as solution.

 

I would also take a moment to thank dufoq3 and Akash_Varuna, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.