Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hey @Tamerlane
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
Sorry for the very late reply, but enabling the logging helped identity the problem. Thanks!
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |