Forum Discussion

WW's avatar
WW
Frequent Visitor
10 years ago

Unable to connect Power BI to SQL

Hello all,    I am facing this error for a few days and it's driving me crazy. I just downloaded Power BI Desktop and hope to connect it to my SCCM database. I have disabled my firewall, check my I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi WW,

Could you please firstly use SQL Server Management Studio to connect to the remote SQL Server instance and check if it is successful? If it also fails, please follow the steps in this blog to troubleshoot this issue.

In addition, we need to verify that if you use a Windows login or SQL login to connect to SQL Server, and how you specify the settings in the following screenshot.


 


Thanks,
Lydia Zhang

  • WW's avatar
    WW
    Frequent Visitor
    10 years ago

    Hi Lydia,

     

    I am able to successfully connect to the remote SQL Server instance from another server. I have used both Windows and Database login, but error appears on both.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi WW,

      Please check that if you can successfully connect to SQL Server from other application(such as Excel) which is installed in the same server with Power BI Desktop.

      And use “IP address, port” or “tcp:computername” as server name to connect to SQL Server in Power BI Desktop.


      Thanks,
      Lydia Zhang

      • WW's avatar
        WW
        Frequent Visitor
        10 years ago

        Hi Lydia,

         

        Thanks for your reply, I have the same error using Excel (Power Query). I tried both tcp:computername and IP,port is still got stuck at "The User was not authorized" message. However I am able to connect from another machine 's SQL management studio to this DB and it works. Not sure what else I have missed...