Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Can't connect SQL Server using some other credentials

Hi,   I'm not able to connect to SQL Server using my Admin ID in Power BI. I can only connect using the ID I'm logged on to the Windows.       If I Shift+Right Click and then 'Run as...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I have tried the Database option as well!

    I get the same error message I've shared in the image.

     

    It doesn't connect to DB using some other credentials until I go to the installation directory of Power BI and Shift+RichtClick -> 'Run as different user'.

    i.e. I have to Run Power BI as different user if I want to login using some other credentials!

Jimmy801's avatar
Jimmy801
Community Champion
6 years ago
Hello

You should be able to connect with whatever user. Try to use database logon instead of windows.

Jimmy
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have tried the Database option as well!

    I get the same error message I've shared in the image.

     

    It doesn't connect to DB using some other credentials until I go to the installation directory of Power BI and Shift+RichtClick -> 'Run as different user'.

    i.e. I have to Run Power BI as different user if I want to login using some other credentials!