SQL User Change in PowerBi

[Anonymous]

Hello,

I have by accident added windows authentication in the SQL Database credentials and instead of database credentials. How do I change the authentication to database authentication when adding a new table?

I have existing in the model tables from the database which are querying fine. I want to add an additional table and I am unable to set to database credentials now that I have added the windows authentication.

The step for adding credentials is missing

[amitchandak · Accepted solution]

@Anonymous , Home Tab -> Transform data -> Data Source Setting

Select the dataset -> clear permissions and try to refresh or add again