cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dasherzx
New Member

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

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;

dasherzx_0-1662717436555.png

 

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.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @dasherzx 

Thank you for your answers.

3. DSN = ODBC Data Source Name

psqlODBC_DSN.png

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).

pbid_pgsqlconnector.png

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @dasherzx 

Thank you for your answers.

3. DSN = ODBC Data Source Name

psqlODBC_DSN.png

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).

pbid_pgsqlconnector.png

Anonymous
Not applicable

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!

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?

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.