You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure

Import Data Connectivity mode loads data into the Power BI service, requiring scheduled refreshes to get current data, which means data would not be immediately 'current' at all times.

Deploying a standard on-premises data gateway is essential for the Power BI service to connect securely to on-premises data sources for shared dashboards. Using DirectQuery connectivity ensures that Power BI queries the SQL Server database directly in real time whenever the dashboard is accessed, guaranteeing that users always see the most current data without requiring scheduled refreshes.

An on-premises data gateway (personal mode) cannot be shared with other users in the organization, violating the requirement for the dashboard to be 'shared between the users'.

Connecting with DirectQuery using a personal mode gateway is possible but still violates the requirement for the dashboard to be 'shared between the users' within the organization.