Odd Behaviour with DB Connection

[fairhaven]

I recently had to make some data source changes to my PowerBI report but the report would not connect to the SQL database.

It's telling me It couldn't authenticate with the credential provided.

I've tested the credential on SMSS on the same computer and it connects without any issue, I can see tables and etc.

What could I have done wrong?

[v-lionel-msft]

Hi @fairhaven ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft]

Hi @fairhaven ,

File -> Options and settings -> Data source settings -> Clear permissions

Try to clear the permission and reconnect.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @fairhaven 

I believe I had the same issue. To me I had to reconnect to the SQL database and that worked well.

Best regards

Alin Oprita