Analyzing and Visualizing Data with Microsoft Power BI — Question 55

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?

Answer options

• 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.

Correct answer: B

Explanation

Choosing option B is correct because using the DirectQuery Data Connectivity mode allows users to see real-time data directly from the SQL Server database when viewing the dashboard. The other options either use Import Data Connectivity, which does not provide real-time updates, or utilize personal mode, which is not suitable for shared organizational dashboards.