Greenplum&Gateway

[Anonymous]

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.

[yuliagx]

I have the same problem since the last update...

Greenplum postgresql, Npgsql 4.0.10

[yuliagx]

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/

[Adm_Prismatec]

I don´t want to use ODBC, when Power BI will resolve this?

[LiviaAraujo]

I'm havind this problem with Power BI desktop since the last update as well

[Anonymous]

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.