Change SQL-connection from Windows to SQL

[Anonymous]

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).

[ankitpatira · Accepted solution]

@Anonymous In power bi desktop go to File -> Options and settings -> Data Source settings. Click Global radio button and select your one or all listed data sources and press delete. Once done you will get optoins to enter credentials again when you reconnect.