Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.