data refresh

[Briggsy]

I am having problems with my data refresh in the powerbI service.  I have three different SQL Servers that are refreshing and all work accept one.  One is giving me a ceretificate error.  I looked on the actual SQL Server and the cert renewed recently so that should be an issue.  If it is, how do i reset what cert PowerBI is looking at?  I have tried to turn on encrypting in power bi desktop, which didn't work ... I tried turing on TCP/IP on the server, that didn't work ... so i am all out of ideas.  Any help would be appreciated.

[Anonymous]

@Briggsy I would suggest taking a look within the gateway logs themselves. The messaging in those is usually much more enlightening to the actual cause of the error.

Installer logs

%localappdata%\Temp\On-premises_data_gateway_*.log

Configuration logs

%localappdata%\Microsoft\on-premises data gateway\GatewayConfigurator*.log

On-premises data gateway service logs

C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log