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] )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Freya , Strange , Try like

 

select * from public.address 
where "ID"  in (select max("ID") from public.address a 
group by "Enterprise_Nbr")