Forum Discussion
Gateway Offline Error
For the past few weeks my BI reports fail to refresh on Friday's with the error message stating that my Gateway is Offline.
I had my company's IT department investigate and they do not see an issue. Also when I check it appears that the Gateways are all Online even as I received this messages.
Anyone experience this issue lately and find a solution? Its strange that this seems to happen every Friday morning.
16 Replies
Hello there IamTDR ! I have had a similar problem last month with two different customers. In the first case, the server was hosted in a Azure VM that, for cost reduction reasons, was shut down everyday at 7pm and rebooted at 8am and I had scheduled updated for hours when the VM was turned off which of course gave an error. The second one was because another software, namely Microsoft Dynamics NAV, had a few scheduled refreshes at the same time as PBI and the database could not handle both processes at the same time and prioritized NAV and cancelled the PBI refresh. I do not know if any of the case apply to you but I hope it may help you in some way!
Hope this answer solves your problem! If you need any additional help please @ me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo GeraldesThanks for the quick reply. I do not believe these are the cause for my Gateway issue but I will pass this message along to my IT Department. Thanks again
Does anyone have a solution to it?
I am the admin that works with IamTDR
I suspect our issue might be similar to the second issue you mentioned. Is there something specific I should look for in the SQL or gateway logs that might confirm this? The weird thing is that these reports are all scheduled to refresh at the same time every day and some days it works and some days it does not. And there doesn't seem to be any real pattern to it that I can spot.
I am continuing to receive the Gateway Offline error mesage on random days. Strangely, the all BI reports will refresh as expected daily and then the following day none will refresh due to Gateway Offline.
I checked the status of my company's gateway and they all state gateway is online.
Does anyone have any other suggestions? Perhaps I need to create a ticket with Microsoft?Hi, IamTDR
This problem should occur in pbi service instead of report server, right? We need more information to judge.
How do you set up schedule refresh?
After receiving the error that the gateway is offline, all reports will not be refreshed, right?
Is your company's gateway open 24 hours?
Is your gateway updated to the latest version? Is it running normally?
Can you share the refresh history of the report?
Refresh summaries for Power BI - Power BI | Microsoft Docs
Best Regards,Community Support Team _ Janey
I opened a ticket with Microsoft and I am awaiting to work with someone on this issue. Will report back if this issue gets resolved.
