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.

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.