Forum Discussion

Jdasne's avatar
Jdasne
Regular Visitor
7 years ago
Solved

unable to load data from sql server domain user

Need your help regarding the issue we encounter regarding the loading of data from SQL server to Power BI. It happens that we tried loading data using a SQL credentials and it works. Unluckily, it fa...
  • Jdasne's avatar
    Jdasne
    7 years ago

    Hi All,

     

    This issue has been resolved by using server name instead of IP address. The weird thing in this issue was our users can previously connect to SQL server using the ip address but apparently it is not working right now. 

     

     

    Thank you

andymc123's avatar
andymc123
Advocate III
7 years ago

I always use server name as opposed to ip address, and I also received this error message.  What I did to fix for myself was ping /a [server ip address].  this gave me back the same server name, but it ended in our domain [company.com].  adding the domain name to the end of the server name in Advanced Query settings allowed me to get past this error message and susccessfully load data.

 

I should note that I originally conencted while in the office, and I was on the VPN when making changes and needed to apply this fix.

 

just thought I would add that comment in case it helps someone else.