Forum Discussion
Solved
SQL Server connections offline
We are facing an unusual problem with the Power BI gateway/service. Dataset refreshes that use existing SQL connections work fine, but their status appears as offline/unreachable in the interface. An...
We solved the issue with the solution described in this post.
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-2024-release/
By trusting all our database servers in the GatewayCore configuration file, we are able to create new connections, and existing connections appear online.
Thanks to Anonymous for the clear instructions in the post.
Can you confirm that there are no logon triggers when the user is logging into SQL Server? I have seen that issue happening in the past. If there is a case where there are logon triggers with regards to your SQL Server, you will have to use an ODBC SQL Server connection to overcome these issues.