Forum Discussion
Solved
Data refresh issue in power bi service
I have created a report in power bi dekstop and published to power bi service. The data source is a sql server databse. I have installed an on-premise gateway. In manage gatways in service it is sho...
The issue is resolved. I was using the server shortname but the certificate had the FQDN. So i used the FQDN in the connection so that the connection string matches the certificate. Now i can refresh the data.
The gateway is online. Data source credentials are also correct. Data source connection is successful. But it is still showing invalid connection credentials error message while data refresh.
The issue is resolved. I was using the server shortname but the certificate had the FQDN. So i used the FQDN in the connection so that the connection string matches the certificate. Now i can refresh the data.