Forum Discussion
Problems with on premises gateway
Hi everyone,
For a client I am trying to get the on premises gateway to work, but despite good credentials and stable connections, I receive either one or two of the following messages when doing a refresh through the gateway:
'Unable to connect to data source undefined'
and/or
“It looks like scheduled refresh failed because the on-premises gateway restarted while refresh was happening. Double-check that the data gateway is continuously running for the next scheduled refresh”
A few things I tried:
- I updated the Gateway to the latest version
- I put HTTPS mode ON
- I tested the connections with the Gateway (test succeeded)
- I restarted the Gateway a few times
- I made the serviceaccount (that connects to the data source) a local admin on the server that has Power BI Desktop and the Gateway
- I tested the refresh in Power BI Desktop (succeeded)
- I republished the dataset after all above changes (note: i did not throw away the existing data set when doing this)
Anything else I missed? Thanks in advance!
- Hi there
What I would do, is to enable the Verbose logging on the Gateway server and see what errors happen.
You could also enable the monitoring with this link below: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance
3 Replies
- Hi there
What I would do, is to enable the Verbose logging on the Gateway server and see what errors happen.
You could also enable the monitoring with this link below: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance Hey Anonymous
We may need to know a few things to make sure we fully understand so we can answer your question most accurately.
1. Are you using the personal gateway or the regular (formerly called enterprise) gateway?
2. What kind of data source are you connecting to?
3. In Power BI Service, did you go to the gear icon -> Manage gateways -> then select the datasource and make sure the credentials and everything were set up in the datasource.
If it is an ODBC I have experienced this m