Forum Discussion
Gateway offline => how to avoid this error ?
Hello All,
I created a Power BI report based on a SQL database. In order to refresh this report on a daily base, I implemented a Gateway on premises: this gateway is using 'windows' as authentification method. The software of the Gateway is installed on my personnal computer, shut down each night and week-end. Let's have a look on my last week refresh history:
| On demand | 12/06/2017 à 10:12:26 | 12/06/2017 à 10:16:07 | Completed | ||
Show | Scheduled | 12/06/2017 à 10:02:03 | 12/06/2017 à 10:08:28 | Failed | The gateway is either offline or could not be reached. |
Show | Scheduled | 11/06/2017 à 10:02:02 | 11/06/2017 à 10:10:15 | Failed | The gateway is either offline or could not be reached. |
Show | Scheduled | 10/06/2017 à 10:02:09 | 10/06/2017 à 10:12:16 | Failed | The gateway is either offline or could not be reached. |
| Scheduled | 09/06/2017 à 10:02:02 | 09/06/2017 à 10:13:47 | Completed | ||
| Scheduled | 08/06/2017 à 10:02:02 | 08/06/2017 à 10:16:16 | Completed | ||
| On demand | 07/06/2017 à 10:59:46 | 07/06/2017 à 11:06:04 | Completed | ||
Show | Scheduled | 07/06/2017 à 10:02:03 | 07/06/2017 à 10:13:05 | Failed | The gateway is either offline or could not be reached. |
| On demand | 06/06/2017 à 12:41:15 | 06/06/2017 à 12:46:42 | Completed | ||
| Scheduled | 06/06/2017 à 10:02:02 | 06/06/2017 à 10:15:23 | Completed | ||
| On demand | 05/06/2017 à 11:42:24 | 05/06/2017 à 11:46:57 | Completed | ||
Show | On demand | 05/06/2017 à 11:03:41 | 05/06/2017 à 11:03:44 | Failed | The gateway is either offline or could not be reached. |
As you can see, once the gateway is offline, no more refreshes work again.
What do I do to fix this issue ?
Each monday, I try to fix this bug but:
- it's impossible to restart the service (Error 1069: the service did not start due to a logon failure)
- it's impossible to launch the microsoft gateway software (error: impossible to contact the Gateway)
So, the only fix I found to unblock the situation is:
- uninstall the microsoft gateway software
- reinstall the microsoft gateway software
- recover the gateway with the revovery password
- then the Gateway is online => I can refresh and pray in order my 2 or 3 next automatic refreshes work.
Of course, it's not really a fix and it doesn't satisfy me. That's why I'm writing this post.
This week, I'm asking to the IT a way to have a computer/server using a permanent session => do you think it will fix my issue? do you see someting wrong in my way to proceed?
Thanks in advance for your help.
Regards,
Philippe
v-huizhn-msftMicrosoft Employee
Hi Philippe,
Based on my understanding, you install On-premises data gateway rather personal.
1. You need to confirm the data resurce(SQL Server) is added successful like the following screenshot.
2. The account used to sign in the gateway is effective.
If they are all fine, but there still have the issue, I suggest you create a support ticket in ther right bottom part here to check your private data.
Best Regards,
Angelia
AngeliaHello,
First thank you to have read me. Here are the screenshots to have a look o nthe settings.
On-Premise GatewayI can connectHere are the settings of the Gateway
Do you I would have less problems using a computer that never shut down ?
And thanks for the link to the support. If I don't have way to fix the gateway today, I will create the ticket tomorrow. And if the solution is simple, I will write the solution here.
Regards,
Philippe
- v-huizhn-msft
Hi Philippe,
Fron your screenshot, your gateway has been configured well. And sometime your refresh work, sometimes not, it's weird. You'd better create a support ticket to check your own personal data.Best Regards,
Angelia