Forum Discussion
Data refresh issue in power bi service
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.
Hi Chiranjit,
I would check to ensure that you have appropriately setup the gateway datasrouce. You will see in the gateway settings if the gateway cannot connect to the data source then you will see a yellow exclamation next to your datasource from the gateway settings.
After confirming the gateway is not hte issuse, you should check in your workspace under the dataset settings, you should see the Data source creditial section, make sure that you haven't missed anything for this dataset setup.
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.