Solved: Edit Credentials for a SQL DB Connection

Anonymous · ‎09-12-2018

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 · ‎09-12-2018

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

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

View solution in original post

Chihiro · ‎09-12-2018

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

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

Anonymous · ‎09-12-2018

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!!!!