Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Johnm_AK89

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

Submitted by on ‎02-01-2024 05:08 PM

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.

 

Error_Setup.png

 

Error_Setup2.png

Error_Parameter example.png

 

 

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?

 

Error.png

 

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

Status: Investigating
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎02-05-2024 12:44 AM

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
Frequent Visitor
‎02-06-2024 02:04 PM

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

Johnm_AK89
Frequent Visitor
‎02-29-2024 05:36 PM

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
Regular Visitor
‎05-02-2024 04:17 AM

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
Frequent Visitor
‎05-02-2024 10:44 AM

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

Idea Statuses