Question

Your team publishes several reports to a shared Power BI workspace. The underlying data comes from an on-premises SQL Server database. Multiple analysts need to configure and manage scheduled refresh for their own reports, and the connection must remain available even when individual team members are on leave. Which gateway configuration should you deploy?

Accepted Answer

Install an on-premises data gateway (standard mode) and add each analyst as an authorized user on the SQL Server data source

Answer

Have each analyst install an on-premises data gateway (personal mode) on their own workstation

Answer

Install a personal gateway on one analyst's laptop and share the workstation credentials with the team

Answer

Connect directly to SQL Server using DirectQuery so that no gateway is required for refresh