Forum Discussion

ptimmerm's avatar
ptimmerm
Frequent Visitor
1 year ago
Solved

Cannot connect to SQL DB w/PBI Desktop - Can with SSMS and ADS

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...
Need Help
Tips and Tricks
  • ptimmerm's avatar
    ptimmerm
    1 year ago

    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.

ptimmerm's avatar
ptimmerm
Frequent Visitor
1 year ago

It is in Azure North Central US. It is listening on 1433.

There has to be something internal to my work network blocking it, but I have no idea what that would be since I can hit it via SSMS and ADS. Might be a GPO thing. Does not seem lie a firewall thing anymore.

I can hit it just fine from Power BI Desktop installed on my personal laptop.

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
1 year ago

ptimmerm 

Hmm. May you can use tools like wireshark and see the network trace?

create one trace while you are connecting from SSMS and one another trace when you are trying to connect from power bi desktop and see if that gives any information.

 

Also, If you are using your organiztion network then you can ask your network team to unblock port 1433 for your ID. As far as I know some organizations might have user/region/system specific network rules

Need a Power BI Consultation? Hire me on Upwork

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!
  • ptimmerm's avatar
    ptimmerm
    Frequent Visitor
    1 year ago

    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.

  • ptimmerm's avatar
    ptimmerm
    Frequent Visitor
    1 year ago

    Appreciate the reply. I do not think this is a port issue as I am able to connect with SSMS and ADS, both of which would also be going out on 1433.

    I tried in Excel and ran into the same issue. My current hypothesis is that there is something in our M365 tenant that is preventing our M365 apps from making data connections to Azure.