Forum Discussion

anisevance's avatar
anisevance
Frequent Visitor
2 years ago

ODBC driver not found error in Power BI service when attempting to refresh data

Good morning all,   I successfully created two data connections to a Power BI desktop instance that lives on-prem. The first of the data connections is to a SQL data source that is also on-prem. Le...
dataflow
Need Help
anisevance's avatar
anisevance
Frequent Visitor
2 years ago

Got it. This is tremendously helpful. I will try two things:

 

1. Installing the driver on the server that hosts my "personal mode" gateway. Is this just the server that my Power BI Desktop instance lives on?

 

2. If the above doesn't work, I will transition the connections to our on-prem data gateway and make sure the ODBC driver is installed on the server that hosts that on-prem gateway. 

 

Is that about right?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply from Greg_Deckler.

 

Hi anisevance ,

 

This error is caused by the specified ODBC driver not being found when connecting to the data source. In the course of your discussion with the superuser, it seems that you have got the right idea, have you tried it in the direction you mentioned and got the expected result?


I found some links for you that I hope will be helpful:

Configure ODBC drivers for PostgreSQL (sqlshack.com)

psqlodbc - PostgreSQL ODBC driver

 

Best Regards,
Zhu

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!