Forum Discussion

Hamdan1234's avatar
Hamdan1234
Helper III
5 years ago

Sql credentials are correct?

Hello,
I am new to power bi. I have got details of SQL database so that I can import data from it. But when I input these details error comes. Is their anything I am doing wrong? I am inputting User name and password correctly. Is database server name correct? As I have observed server name to be alphanumeric but it is numerical

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Hamdan1234 

    You can use some other client tools (e.g. SSMS) to test whether you have access to the database from the same computer where your Power BI Desktop is running. From the screenshot, you are using the IP address to connect to the database server. Usually the IP address and alphanumeric server name are both supported to connect to a database server. But if database Admin has limited the access, it may fail. So just use database client tool to test whether you can connect to the database with these server/DB names and credentials. You can also confirm these from your DB Admin.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.