locked
Problem to connect to connect to PostgreSQL DB RRS feed

  • Question

  • Hello everyone,

    I am struggling trying to establish a connection within Power BI Desktop with a PostgreSQL DB.

    First I became an error because I hadn't installed npgSQL Library.

    Now I simply become a "Failed to establish a connection..." error.

    Anyone having a clue?

    Thanks for your reply

    Wednesday, November 25, 2015 10:41 AM

Answers

All replies

  • Hi Nicolas,

    Does the error provide more information? Are you able to connect to your database using other tools?

    Thanks,
    Tristan

    Wednesday, November 25, 2015 7:13 PM
  • Hi

    I'm having this same issue.

    It says :

    "Details: "PostgreSQL: We were unable to find a database provider with invariant name 'Npgsql'.
    This error could've been the result of provider-specific client software being required, but missing on this computer.  To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'Npgsql version 2.0.12': https://go.microsoft.com/fwlink/?LinkID=2827162""

    I don't know what this is though.

    Can anyone help out?

    I have an application that I got with the database that uses the database, but it has very weak reporting capability and I was hoping this tool could do better.

    Also is there anyway to get a notification on this trail?

    Thanks

    Mark

    Wednesday, February 24, 2016 7:00 PM