Forum Discussion
Solved
On-premises gateway - data source refresh Invalid connection credentials
I have installed On-premises gateway on server machine and mode of the gateway is On-premises data gateway I have create 3 data sources in manage gateway screen in power bi online,all three data sou...
bhaskariksl Check out this thread, it will most likely solve your issue.
Hi buddy,
This issue appears when Power BI app try to connect to SQL server. where as SQL server needs authentication for this.
Power BI installer creates a certificate to authenticate with SQL server and sometimes this certificate is not added in sql network configuration.
Add certificate manually at following location:
SQL Server Configuration Manager > SQL Server Network Configuration > Right Click Protocols for (Instance name) > Properties > Certificate
Thank you , I had the same problem and following your instructions fixed it :) I had to make sure the FQDN name of the certificate match when creating a new connection in PBI Desktop.