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 database in my company, i should use On premises gateway for this or Personal Gateway?2) What are the advantages and disadvantages of each option? Why should i use Personal Gateway if i have the On Premises Gateway?3) When i config the Gateways in my Power BI Organization, this gateway must be On premises? Its better to get it centralized, all my reports will use the same Database...4) On that field on red, i need to put the location of the database? Like the IP address...?Thanks for all guys!Waiting for one answer...! :D

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

Personal Gateway X On Premises Gateway | Microsoft Fabric Community

9 Replies

ankitpatira
Community Champion
9 years ago
brunozanoelo

1. You should use on-premises gateway for anything work related. Personal gateway is for personal use to be installed on your laptop.

2. Ideally if you have on-premises gateway you should not use personal gateway also. You should have your data flowing through one gateway only. If you have lots of data sources (test, prod etc) then you should have multiple on-premises gateway (test gateway, prod gateway) but they should be on-premises gateway not personal.

3. As said above it depends we have multiple instances of on-premises gateway running for test, uat and prod reports.

4. You need to put ip or alias name or whataever that identifies your data source but it should be same as used for your report ie you can't use ip for report and alias name for the gateway.
- brunozanoelo
  Post Patron
  9 years ago
  I got all the answers! thank you for helping me my friends!
  
  Many Thanks!!!
  
  :D
  - 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
Not applicable
9 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