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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

So, you created that ODBC connection? And it is the right number of bits, 32/64? 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes, the ODBC connection string (without the dsn part) is working fine (connection successful). 

But when I try to refresh my data, an error occurs and PowerBI asks me to add a connection with the same string + "dsn=dBase Files". If I try to add that suggested connection, I get the error you see in the image.