Forum Discussion

Freya's avatar
Freya
Regular Visitor
3 years ago
Solved

Native Query

Hi, I'am a newbi to PBI and I have a question. I am using PowerBI Desktop which is linked to a PostgreSQL-database.  There are very large tables so I would like to limited the linked tables with Di...
Need Help
  • Freya's avatar
    Freya
    3 years ago

    Found it ğŸ™‚

    = Value.NativeQuery(PostgreSQL.Database("000.000.00.0:5432", "kbo"), "select * from address where ""ID"" in (select max(""ID"") from address group by ""Enterprise_Nbr"")", null,[EnableFolding=false] )

Freya's avatar
Freya
Regular Visitor
3 years ago

I figured out how to enable the query folding but the downside is that I have to convert the sql statement manually.
This one works:
= Value.NativeQuery(PostgreSQL.Database(".000.000.00.0:5432", "kbo"), "select * from address", null,[EnableFolding=false] )

But when I try the query that I need I get an error.  I can't seem to find the error in the syntax.
= Value.NativeQuery(PostgreSQL.Database("000.000.00.0:5432", "kbo"), "select * from address#(lf)where ""ID""  in (select max(""ID"") from address a group by ""Enterprise_Nbr""", null,[EnableFolding=false] )

 



 

 

 

  • Freya's avatar
    Freya
    Regular Visitor
    3 years ago

    Found it ğŸ™‚

    = Value.NativeQuery(PostgreSQL.Database("000.000.00.0:5432", "kbo"), "select * from address where ""ID"" in (select max(""ID"") from address group by ""Enterprise_Nbr"")", null,[EnableFolding=false] )