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 that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
A. Deploy an on-premises data gateway. Connect to the data by using the Import Data Connectivity mode.
B. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode.
C. Deploy an on-premises data gateway (personal mode). Connect to the data by using the Import Data Connectivity mode.
D. Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode.
