Forum Discussion

brunozanoelo's avatar
brunozanoelo
Post Patron
9 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
    9 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

brunozanoelo's avatar
brunozanoelo
Post Patron
9 years ago

Hi Anonymous, some error ocurred... i already check all my settings and are fine, the correct ODBC name driver is POWERBI_FIREBIRD and the dsn should be dsn=POWERBI_FIREBIRD, right? I already unninstalled Personal Gateway of my computer and reseted, i have installed just the on premise Gateway. What should i do? 

Error Stats: 400.

Anonymous's avatar
Anonymous
Not applicable
9 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

  • brunozanoelo's avatar
    brunozanoelo
    Post Patron
    9 years ago

    Got it!!

    :D

    Thank you again Anonymous! Have a nice day!! 

  • AgoZ_KH's avatar
    AgoZ_KH
    Resolver 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? 

       

       

       
  • panda0071's avatar
    panda0071
    Regular Visitor
    2 years ago

    Creating a system dsn odbc in the gateway server fixed my connection issues