Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

dataflow
Need Help

5 Replies

  • LiviaAraujo's avatar
    LiviaAraujo
    Frequent Visitor
    6 years ago

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

  • yuliagx's avatar
    yuliagx
    Frequent Visitor
    6 years ago

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

    Greenplum postgresql, Npgsql 4.0.10

     

    • yuliagx's avatar
      yuliagx
      Frequent Visitor
      6 years ago

      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's avatar
        Adm_Prismatec
        New Member
        6 years ago

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