I am trying to connect PowerBi to a local SQL Server instance.
It has previously worked with a direct Windows Authentication. I tried changing it to a SQL Server Authentication. No luck.
I have specified which login type it was referring to.
The error it reports: "We couldn't authenticate with the credentials provided". I logged in without issues on both authentication methods in SQL Server Management Studio - works perfectly.
What else can I try?