Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Power BI reports connection with PostgreSQL

Hello,

 

I have a report which is already connected with Sybase database. But working with additional data I need also connect same report with PostgreSQL too. So how to implement this?

Need Help

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Analitika , if this is an import mode add data from PostgreSQL too. If direct query, You might have to move common dimension in import mode.

    • Analitika's avatar
      Analitika
      Post Prodigy
      5 years ago

      Data will be from sybase and postgresql, I added postgresql database but still not works, seems something with connection. Can I use PostgresSQL. databases in query?

  • Analitika's avatar
    Analitika
    Post Prodigy
    5 years ago

    Sybase was defined in functions (queries) in data transform, so how use postgresql with that quries?

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Analitika , if you plan to merge data, You have to bring them in a separate table using PostgreSQL Driver or ODBC driver and merge/append the data.

  • Analitika's avatar
    Analitika
    Post Prodigy
    5 years ago

    I am getting this error whenever I am tryingto refresh the report:

    OLE DB or ODBC error: [DataSource.Error] Sybase SQL Anywhere: Connection error: Connection was dropped (may not be a SQL Anywhere server) . An unexpected exception occurred.