Power BI refresh fails 90% of the time with postgres ODBC

[dasherzx]

We are having refresh errors 90% of the time for our reports. Repeatedly refreshing it manually might solve the problem. There are no problems refreshing via powerbi desktop app on the report server.

Driver={PostgreSQL ANSI(x64)}; Server=xx.xx.xx.xx; Port=5432; Database=xxx; Connection Timeout=500;

SessionID: 0622896a-4188-495f-9aef-57291a069a69
[0] -1055784932: The 'Driver' property with value '{PostgreSQL ANSI(x64)}' doesn't correspond to an installed ODBC driver.. The exception was raised by the IDbCommand interface.
[1] -1055129594: The current operation was cancelled because another operation in the transaction failed.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[Anonymous · Accepted solution]

Hi @dasherzx 

Thank you for your answers.

3. DSN = ODBC Data Source Name

4. I mean the PostgreSQL connector that Power BI Desktop has by design. You're right, the underlying techno is NpgSQL 4.0.10 (details here).

[Anonymous]

Hi @dasherzx 

• Is the Power BI Report Server (PBIRS) on-premises?
• Is the psqlODBC Driver installed on the server where PBIRS is deployed?
• Is the ODBC DSN declared on the server where PBIRS is deployed?
• Is it an option for you to use the PostgreSQL Database connector of Power BI instead of the ODBC connector?

Thanx in advance for your answers.

Have an amazing day!

[dasherzx]

1. Yes

2. Yes

3. Mind clarifying what's DSN? If you mean the tables in the SQL query, no the postgres database server is on another machine with another IP. 

4. Yes but probably the nuclear option. Do you mean NPGSQL 4.0.10?