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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi brunozanoelo,

Adding to other post, from your last screenshot, I note that you want to add odbc data source under gateway. In this case, you can input the connection string following the steps below.

1. Check your dsn name(testodbc1 in my scenario) in ODBC administrator or in Power BI Desktop if you have connected to the odbc data source from Power BI desktop.

 

2. Add data source under gateway by entering connection string , account and password as shown in the following screenshot .

 

3. Schedule refresh for the dataset in Service.

 


Thanks,
Lydia Zhang