Question

A colleague who created several published reports and their scheduled refreshes is leaving the company. Their on-premises data gateway connection was configured under their personal account, and refreshes will fail once their account is disabled. As a Power BI administrator, you need to ensure these scheduled refreshes continue working with minimal reconfiguration. What should you do?

Accepted Answer

In the on-premises data gateway management page, add yourself or a service account as a user on the gateway data source, then reassign the data source credentials.

Answer

Delete each affected semantic model and republish it from Power BI Desktop under your own account.

Answer

Convert each semantic model to DirectQuery so that no scheduled refresh is required.

Answer

Install a new personal gateway under your own account and reconnect every report to it manually.