Forum Discussion

jdormer's avatar
jdormer
Helper I
8 years ago
Solved

SQL - "We couldn't authenticate with the credentials provided"

Good morning,    I am having difficulty connecting from my local Power BI Desktop to a SQL server in a client's environment. My account has read access on the database, however, when I try to conne...
Need Help
  • rocky09's avatar
    rocky09
    8 years ago

    You need to provide Server credentials not windows. Use Other Tab.

rocky09's avatar
rocky09
Solution Sage
8 years ago

try this:

 

Get Data --> Blank Query-->

 

= Sql.Database("xx.xx.xxx.xx", "SchemaName", [Query="Query here"])

 

First time, it will ask for credentials, provide SQL Credentials. :).

 

I hope, this will help.

  • jdormer's avatar
    jdormer
    Helper I
    8 years ago

    Thanks, rocky09. Currently, I am going to Get Data -> SQL Server, entering the Server and DB, then selecting Windows Credentials and entering Windows credentials that have read access on the database. Can the connection be made with Windows credentials?

    • rocky09's avatar
      rocky09
      Solution Sage
      8 years ago

      You need to provide Server credentials not windows. Use Other Tab.

Related content