Forum Discussion
Cannot connect to SQL DB w/PBI Desktop - Can with SSMS and ADS
Just wanted to say thank you to everyone for their assistance. We have resolved the issue. Turns out it was a firewall thing, but not a straight blocking of 1433 outbound. There were some AppIDs that were inconsistent/misconfigured.
Hello FarhanJeelani
Thank you so much for the detailed response. I tried a number of your suggestions and have had no luck.
I am confident there is no traffic being blocked. I think I might have a driver issue of some sort. If I create and ODBC DSN, using the most current ODBC driver, I get all of the Entra ID options for authentication. I can reference the ODBC as the data source in Power BI Desktop and utilize the connection. This is not ideal but is a new data point.
What I notice is that when I go to setup just the SQL Server connection on Power BI Desktop, the connection configuration in the app does not show any of the Entra options or being able to set the encryption connection to Strict, like I do in SSMS, and like what works when I set up the ODBC. It feels like something is missing. I am running the most current version of the app, February 2025. When I click on SQL Server for the data source, I see the following. Is this what you see/what I am supposed to see?
Nowhere do I have the Entra related options I see in other tools.
Thoughts?
Super UserIf you want to change the encryption option from power bi desktop, open datasource settings, (it appears under "Transform data" drop down. Click on global datasources (Considering you have have not establisshed the connection successfully) and then find your sql server and then right click on it and then in the menu that appears click on edit
There you will find a check box, Encrypted, un check that box and see if that solves the problem
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Hi all. I must be making a simple mistake, but here's my situation.
I spun up a new Azure SQL DB. It allows for Entra Authentication and SQL Server Authentication. Firewall rule has been setup to allow for connection from my local IP.
From SSMS and ADS I can connect without issue. In SSMS, I have successfully connected with the Entra Admin account (using Microsoft Entra MFA authentication), with a separate Entra account I added (using Microsoft Entra Integrated authentication) and with a SQL Server authentication account I have created. Everything works as expected.
When I launch Power BI Desktop (latest version) and attempt to connect to this Azure SQL DB, using the same types of authentication that work for SSMS, I get this:Power BI Desktop is on the same machine as SSMS and ADS, so this is not a server firewall issue. I see no scenario where it is a network latency issue.
I should add that I see this same error when I use the .pbids file downloaded right from the server in Azure.
What am I missing? Why is Power BI Desktop unable to make this connection? It feels "encryption-y" but I cannot figure out where.Thanks in advance!
Thanks for the reply. Unfortunately that option appears to just be binary, "encrypt or not". It is not the same level of configuration available in, for example, the ODBC driver setup I referenced.
- tharunkumarRTK
have you tried unchecking the Encrypted? if yes, then were you able to connect to you sql server?
I did try that and still no luck connecting.
