Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello.
Long story short (and thanks to developers who created Forum which destroys posts /s).
Datasource - Greenplum.
Power BI Desktop - works well, data is retrieved.
Report and dataset is uploaded. Refresh through Gateways (both personal and not) do not work: "Failed to update data source credentials: PostgreSQL: 42P01: relation "information_schema.character_sets" does not exist".
Yes, this is Greenplum and this relation do not exist. But why refresh works in Desktop?
Refresh from Postgresql works well.
Support don't help.
With best regards.
I have the same problem since the last update...
Greenplum postgresql, Npgsql 4.0.10
UPDATE
The problem with connecting through the postgres connector was not resolved.
Alternative connection through ODBC works fine:
let
Source = Odbc.Query("Driver={PostgreSQL ANSI(x64)};Server=dwh-pro******e1.ru.mgo.su;Port=****;Database=****;", "select * from....'")
in
Source
more info http://niftit.com/connecting-power-bi-to-postgresql/
I don´t want to use ODBC, when Power BI will resolve this?
I'm havind this problem with Power BI desktop since the last update as well
Well, I found a sort of solution (pray for that).
GatewayInstall.exe
https://www.microsoft.com/en-us/download/confirmation.aspx?id=53127 downloaded at 2019-08-23 - works.
PowerBIGatewayInstaller.exe downloaded today - don't work.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!