Forum Discussion
Solved
Power BI Gateway. "A specified logon session does not exist"
Hello, I'm experiencing a persistent issue with Power BI Gateway when attempting to connect directly to a SQL Server Tabular model data source. Here are the key details: Environment: SQL Server con...
I found a workaround. The connection works when using Dataflows and Azure Analysis Services, as it allows selecting "Basic" as the authentication kind.
rohit1991
Super User
Super UserHere's a condensed list of steps to try:
- Check OLE DB Driver: Update or try a different stable OLE DB driver version.
- Session Timeout: Adjust timeout settings on both SQL Server and Power BI Gateway to prevent premature session closure.
- Performance Profile: Set the gateway's performance profile to "Balanced" or "Reliability" for better connection stability.
- Firewall/Antivirus: Temporarily disable them to rule out interference.
- Event Viewer: Look for related errors in the Event Viewer logs on the gateway machine.
- Re-add Data Source: Remove and reconfigure the SQL Server data source in the Power BI Gateway.
Hope this helps 🙂
Thank you for the recommendations! I appreciate the guidance
- I'll check
- All default timouts on AS: 60 for connection, no time limit for orphan.
- The Gateway is operating entirely within our corporate network, without any reliance on external or potentially unstable connections like VPN, NAT, or the internet.
- Firewall/Antivirus. The error persists even when the firewall and antivirus are completely disabled, so these do not appear to be contributing factors.
- I will review the Event Viewer logs on the gateway machine in detail, but at first glance, I haven’t found any additional errors related to this issue.
- We've tried removing and reconfiguring the SQL Server data source in the Power BI Gateway countless times, but unfortunately, this hasn't resolved the issue.