Forum Discussion
Helper IIcan not refresh dataset (both from 'refresh now' and 'schedule refresh'
I was able to resolve it by:
1) uninstalling on-premises data gateway
2) using Power BI - personal.
See here for solution: http://community.powerbi.com/t5/Service/Enterprise-gateway-quot-cannot-connect-to-the-mashup-data-source/m-p/28262#M7708
Just for anyone else who ends up on this thread as I did - I had a similar issue but quite different.
At one time we had purchased Entrust certificates to use for Encryption in Flight use between SQL Servers and some Oracle BI solutions. The database we were attempting to connect to had some old remnants of the expired certificate that was no longer being used. The thumbprint was not removed from the registry entry and the certificate was still present in the certificate store.
This was the reg key to remove the value of:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceName\MSSQLServer\SuperSocketNetLib\
Key: Certificate
Once this was removed from the registry and the certificate was deleted (even though SQL was not using the certificate correctly) - I restarted the instance, and I was able to schedule refreshes through my Enterprise Gateway without issue.