Forum Discussion

brunozanoelo's avatar
brunozanoelo
Icon for Post Patron rankPost Patron
10 years ago
Solved

Personal Gateway X On Premises Gateway

Hi guys! I have some questions about the difference between Personal and On Premises Gateways. I already read some topics but i didn't understood very well. The questions: 1) I have a local ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi brunozanoelo,

    Do you create User DSN or System DSN in ODBC administrator? Based on my test, I get the same error as yours when I create a user dsn that points to SQL Server, however, everything works well when I create a system dsn.


    Thanks,
    Lydia Zhang

AgoZ_KH's avatar
AgoZ_KH
Icon for Resolver I rankResolver I
7 years ago

I have the same problem on my gateway. I can't configure a new data source. Of course I have active an ODBC connection under System TAB and the connection is up & running.

 

The strange thing is that I had configured over a first machine the same connection ... and gateway was functioning. Thinking about a conflict (the dns was the same) I have cancelled the first gateway but didn't resolve the problem.

 

Can the problem is refererred to a misconfiguration of the local machine?? Because this is the only significant difference between the two cases. And if right what can be the problem??

 

Thanks in advance to whom help me to solve

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have the same issue when configuring the Data Source Settings of the ODBC connection in the Gateway clusters. The ODBC connection from Power BI Desktop works fine. We use a system DNS driver and tried both Gateway on-Premise and personal mode. Does anyone know how to resolve this?