Hello, Attempting to use the On-Premise Gateway and it works fine for one day and then fails.
I get the error: "Gateway or Datasource no reachable".
I login to the computer with the gateway and it appears to be working fine.
If I remove and readd the gateway it will work again.
Any ideas?
8 Comments
v-qiuyu-msftCommunity Support
Hi michael_mcclari,
Please update the on-premises data gateway to the latest version then test again.
If the issue still occurs, please go to Manage Gateways firstly, check if the gateway is online and data source connection is successful. If there is any error with gateway or data source, please share detail error information with us.
Best Regards,
Qiuyun Yu- v-qiuyu-msftStatus changed:NewtoNeeds Info
- Last refresh failed: Mon Apr 29 2019 12:20:59 GMT-0700 (Pacific Daylight Time)
Unable to connect to the data source undefined.Hide detailsUnderlying error code: -2147467259 Table: search?jql=project%20%3D%20%22Tier%203%20Application%20Support%22%20and%20(resol. Underlying error message: Web.Contents failed to get contents from 'https://ent-jira.nuance.com/rest/api/2/search?jql=project%20%3D%20%22Tier%203%20Application%20Support%22%20and%20(resolutiondate%20%3E%20startOfYear()%20or%20resolution%20is%20empty)%20&maxResults=1000' (400): DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: Web Microsoft.Data.Mashup.ValueError.DataSourcePath: https://ent-jira.nuance.com/rest/api/2/search Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Microsoft.Data.Mashup.ValueError.Url: https://ent-jira.nuance.com/rest/api/2/search?jql=project%20%3D%20%22Tier%203%20Application%20Support%22%20and%20(resolutiondate%20%3E%20startOfYear()%20or%20resolution%20is%20empty)%20&maxResults=1000 Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net Activity ID: be5e37b5-43d7-450c-a13a-2af707686e37 Request ID: 156cefe7-0be4-aca4-e773-e674d8b52139 Time: 2019-04-29 19:20:59Z From this screenshot below, gateway looks to be fine, but still no refresh.
- v-qiuyu-msft
Hi michael_mcclari,
Please click on the highlighted button below to go to Manage Gateways, find the web data source, check if it's connection is successful.
If the data source connection is successful in Manage Gateways section, please refresh the same report in Power BI desktop to see if the issue occurs.
Best Regards,
Qiuyun Yu Yes, it says it is successful. Why is this thing so buggy?
- v-qiuyu-msft
Hi michael_mcclari,
It's hard to provide further help on forum side. I would suggest you create a support ticket to get dedicated support.
Best Regards,
Qiuyun Yu - v-qiuyu-msftStatus changed:Needs InfotoDone
