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 

If 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

 

 

 








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

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's avatar
    tharunkumarRTK
    Icon for Super User rankSuper User
    1 year ago

    ptimmerm 

    have you tried unchecking the Encrypted? if yes, then were you able to connect to you sql server?

    • ptimmerm's avatar
      ptimmerm
      Frequent Visitor
      1 year ago

      I did try that and still no luck connecting.

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

        Ok, May I know where this SQL server is hosted?
        what is the port number that you are using to connect to it from sql server or ADS?

        if it is not 1433 then can you try appending the port number to the hostname?
        like <Hostname::1433> 

         

        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!