🔥 3-day streak
Microsoft Power BI Data Analyst84 / 205
Question 84 of 205

Your organization runs scheduled refresh for several semantic models that connect to an on-premises SQL Server through a single on-premises data gateway (standard mode) installed on one server. During recent maintenance windows on that server, all refreshes failed and reports showed stale data. You must ensure refreshes continue to succeed even if one gateway machine is offline, with the least ongoing administrative effort. What should you do?

Reviewed for accuracy · Report an issueNext question