Power BI SQL connection to Fabric Lakehouse SQL Analytics Endpoint - Unable to connect

[Johnm_AK89]

Setup:

I have Dev Test and Prod Fabric workspaces with a development pipeline built around them. Because of the limitations right now in fabric, when I promote a report from Dev to Test, the Semantic Model still points to the Dev and not to the Test lakehouse/SQLendpoint. As a workaround, I've been parameterizing the SQL endpoint string as a database and connecting to it via a SQL connection, and after promoting, I can update the parameter to the Test environment's sql endpoint string. This way I don't have to have a Dev Test and Prod version of the same report pointing to their respective lakehouse tables.

 

 

 

Problem:

I've been unable to connect to the sql endpoint using this method and I've been getting a consistent error with connectivity. Our IT is used to more on-prem solutions and haven't been able to help much with issues like this. The existing cloud reports seem to be fine, but I can't start any new reports using this method. Any ideas?

 

*edit* update: our IR might be down, more to come tomorrow once our IT is back.

[v-xiaoyan-msft]

Hi @Johnm_AK89 ,

During my investigation,You can try these steps that may help:

• check the login details and server name
• login to SQL Server Management Studio with same details
• turn off proxy.
• turn off the firewall.
• check if all TCP\IP configurations in the configuration manager enabled.
• check all set to port 1433

Best regards.
Community Support Team_Caitlyn

[Johnm_AK89]

Update: waiting on an internal IT ticket to check on the Firewall and local connectivity.

[Johnm_AK89]

IT Confirmed it's something to do with our Internal monitoring/security software that's likely messing with the pre-login handshake. Not resolved but I have IT's ear now. Thank you.

[nhw512]

Hi @Johnm_AK89 , 
I believe I'm currently facing the same problem, issued a ticket to IT already. 
Did you manage to resolve this already?
If so, I'd be grateful for some hints to accelerate our process.

BR
Nick

[Johnm_AK89]

The issue I had was resolved through our IT team and a ticket to our internet security software vendor. They ended up whitelisting several urls and ips (meeting took an hour troubleshooting with me testing after each rule update).
Add Power BI URLs to allowlist - Microsoft Fabric | Microsoft Learn
Download Azure IP Ranges and Service Tags – Public Cloud from Official Microsoft Download Center