Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Greenplum&Gateway

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.

5 REPLIES 5
yuliagx
Frequent Visitor

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

Greenplum postgresql, Npgsql 4.0.10

 

image.png

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?

LiviaAraujo
Frequent Visitor

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

Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors