Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.