Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Gateway - Unable to connect to data source

Hello   I am trying to set up an on-premises data gateway. Everything seems to be working fine, and I am able to create data sources (the green check appears, ✔️ Connection successful) using an ODB...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thank you Anonymous, as you pointed out "Power bi service has different security and policy so some of the connection string works on desktop, but failed on power bi service side"

     

    In my case, I was using a User DSN. It works in Power BI Desktop and seemed to work in Power BI Service since I get a "Connection successful" message, but it didn't.

    I had to add a System DSN using the ODBC DataSource Administrator tool. And then, use it in my connection string:

     

    driver={PostgreSQL Unicode(x64)};server=myserver.com;port=5432;database=my_db;dsn=MyNewSystemDsn

     

    Now it is working like a charm

     

    Thanks for your help

     

    Jose

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you Anonymous, as you pointed out "Power bi service has different security and policy so some of the connection string works on desktop, but failed on power bi service side"

 

In my case, I was using a User DSN. It works in Power BI Desktop and seemed to work in Power BI Service since I get a "Connection successful" message, but it didn't.

I had to add a System DSN using the ODBC DataSource Administrator tool. And then, use it in my connection string:

 

driver={PostgreSQL Unicode(x64)};server=myserver.com;port=5432;database=my_db;dsn=MyNewSystemDsn

 

Now it is working like a charm

 

Thanks for your help

 

Jose