'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix an Offline On-Premises Data Gateway in Power BI
Question details
The user needs to resolve an issue where Power BI scheduled refreshes fail because the on-premises data gateway is showing as offline or cannot be reached.
- Product
- Power BI
- Device & OS
- not provided
- Scenario
- Attempting to execute scheduled data refreshes for Power BI dashboards using an on-premises data gateway.
- Observed behavior
- The on-premises data gateway goes offline or becomes unreachable, causing scheduled data refreshes to fail.
Ensure you have administrative access to the physical or virtual machine where the Power BI on-premises data gateway is installed, and verify its network connection.
Verify Gateway Machine and Service Status
Check the physical machine and the gateway service to ensure it is powered on and running properly.
The most common reason for an offline gateway is that the host machine is turned off, disconnected from the network, or the background service has stopped.
Ensure the computer hosting the gateway is turned on, not in sleep mode, and has an active internet connection.
Open the On-premises data gateway app on the host machine and check the Status tab to confirm the service is running and connected.
Sign in to the gateway app and ensure your account and data source credentials are correct and have not expired.
Update or Reconfigure the Gateway
Ensure your gateway is running the latest version and is not being blocked by network security protocols.
Seek Advanced Support from the Power BI Community
If basic troubleshooting fails, the issue may require service diagnostics from Microsoft experts.
Manage and Analyze Your Data with WPS Office
While enterprise data connections require complex gateways, WPS Office provides a lightweight, free alternative for your daily data analysis, reporting, and visualization needs. Enjoy full compatibility with Microsoft Office formats and an intuitive interface.
- 1. Download and Install WPS Office: Visit the official WPS Office website to download the free suite for your operating system.
- 2. Open Your Data Files: Launch WPS Spreadsheets and open your .xlsx or .csv datasets seamlessly without format conversion.
- 3. Analyze and Visualize: Utilize built-in PivotTables, charts, and data tools to extract insights and generate reports.
Frequently Asked Questions
Why is my Power BI data gateway showing as offline?
This usually happens if the host machine is turned off, disconnected from the internet, or if the on-premises data gateway service has stopped running unexpectedly.
How do I restart the on-premises data gateway service?
Open the Services app (services.msc) in Windows, locate 'On-premises data gateway service', right-click it, and select Restart to refresh the connection.
Can a firewall block the Power BI gateway?
Yes, strict firewall or proxy settings can block the gateway from communicating with Power BI cloud services. You may need to whitelist specific IP addresses and ports to allow outbound traffic.
Does updating the gateway fix offline issues?
In many cases, yes. Microsoft releases monthly updates for the gateway, and running an outdated version can lead to connectivity and sync failures.
