On-Premise Gateway Fails Constantly

[michael_mcclari]

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?

[v-qiuyu-msft]

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 

[michael_mcclari]

Last refresh failed: Mon Apr 29 2019 12:20:59 GMT-0700 (Pacific Daylight Time)
Unable to connect to the data source undefined.Hide details

Underlying 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%20Suppor...' (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%20Suppor...
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

[michael_mcclari]

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 

[michael_mcclari]

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