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
wvanpeel
Advocate II
Advocate IIHi, I'm having same issue, all worked fine until some days ago. Direct query sources work still fine, only import gives this error.
In the solution, what do you mean with "PowerBI installer " ?