Forum Discussion
Error when creating a new connection associated on Gateway cluster
Hi community. Im having problems when i try to create a new connection on Power BI portal with admin rights. Im trying configure a sql server connection but when i try to create, the...
GilbertQ
Super User
Super UserHi Ivanrc98
If you can, please confirm if we have any log on triggers on your SQL Server source. If you do, that is why you're getting the error and the only way I found to overcome that is to use an ODBC data source on your gateway.
Hi Gilbert,
Thanks in advance, but we don't have any records in triggers in this DB. Another thing when I try to configure this connection in the portal is that an error appears instantly, it seems that it does not cross the on-premise data gateway.
BR