Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Change SQL-connection from Windows to SQL

In a pbix-file I'v made different connections to a sql-dataserver.

In the development-fase I'v made the error to connect by using my windows-account. How can i redefine this connection for using a sql-account.

I don't see this information in the advanced queries with the definition of the connection. (I see servername, table name or sql-instruction, but no login-info).

 

 

2 Replies

Replies have been turned off for this discussion
  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Try going to File | Options and settings | Data source settings. Double click your SQL server connection and you should be able to edit the credentials.