Forum Discussion
Post PatronPersonal Gateway X On Premises Gateway
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
Community Champion
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.
Post PatronI got all the answers! thank you for helping me my friends!
Many Thanks!!!
:D
- brunozanoelo
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.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
Got it!!
:D
Thank you again Anonymous! Have a nice day!!