Edit Credentials for a SQL DB Connection

[soldstatic]

I've attempted to add a connection to a SQL DB, but accidentally told Power BI to utilize my windows credentials. Doing this failed because I needed to use server authentication. However when I go to 'get data' I type in the server name and hit connect, and it spins and then errors out with a named pipe issue. It does not ask me how I want to authenticate anymore. Is there a way to make Power BI forget how I tried to connect? Or is there something else going on? I was able to log in to the DB via PLSQL.

[Chihiro · Accepted solution]

You can try going to Data Source settings and "Edit Permissions".

There you will find Credentials section, where you can edit Type.

[soldstatic]

You're a lifesaver, for 1. For 2: I didn't realize I had to click over to 'global permissions' to get to it or I could've been done with this an hour ago lol. thanks again!!!!