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

Freya's avatar
Freya
Regular Visitor
3 years ago

I think I am a little bit closer now.  👍 I get an other error message (see below).  From other posts I understand that you can change the EnableFolding option in Transform Data / Source.  But I can't seem to get there.
If I click "Retry" I get the same message (seems logical), if I click "Edit" than I get the startscreen from GetData where there isn't an option to enablefolding.
I am using a blank pbix-file without any links, imports.

 

https://learn.microsoft.com/en-us/power-query/connectors/postgresql