Power BI Gateways: Why Sleeping Machines Stop Reports Updating
Diesen Beitrag auf Deutsch lesen
Power BI gateways connect cloud reports to data sources and must remain available to keep refreshes working.
TL;DR
Power BI gateways connect cloud reports to data sources that cannot send data directly to the cloud. A gateway machine must remain available: if it sleeps, reports can stop updating. The episode covers the data round trip, three gateway kinds, placement in Microsoft 365 and Azure, planning limits, and common troubleshooting mistakes.
Original by Mirko Peters, on M365.FM. Read the original · suggested by Mirko Peters
This is our own summary, not a republication or full translation.
Governance takeaway
- Admins/CoE: Keep the gateway machine available, because sleep or other availability problems can leave Power BI reports showing outdated data.
- Leadership/Business: Treat gateway availability as part of reporting reliability, because a finance dashboard can show data from a previous day when the connection stops working.
- Security/Compliance: Include gateway placement and operating limits in planning, because the episode identifies them as factors to understand before scaling.
Frequently asked questions
Why does a Power BI report stop updating when the gateway machine sleeps?
The report can stop receiving refreshed data because the gateway machine holds the connection and is no longer available.
What does a Power BI gateway do between local data and the cloud?
A gateway carries the data connection between a source that cannot send data directly and the cloud report.
How many Power BI gateway kinds does this episode cover?
The episode covers three kinds of Power BI gateway and explains where gateways fit in Microsoft 365 and Azure.