Analyzing and Visualizing Data with Microsoft Power BI — Question 57

You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular database named SalesDB in Microsoft SQL
Server Analysis Services (SSAS). The report will be published to the Power BI service.
You need to ensure that the report published to the Power BI service will access the current data in SalesDB.
What should you do?

Answer options

• A. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option.
• B. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Import Data Connectivity mode.
• C. Deploy an on-premises data gateway (personal mode) and configure the connection to SalesDB to use the DirectQuery Data Connectivity mode.
• D. Deploy an on-premises data gateway and configure the connection to SalesDB to use the DirectQuery Data Connectivity mode.

Correct answer: A

Explanation

The correct answer is A because using the 'Connect live' option with an on-premises data gateway allows the report in Power BI service to access real-time data from the SalesDB. Options B and C do not provide real-time access, as Import Data Connectivity mode requires data to be imported rather than accessed live, and personal mode is not suitable for shared reports. Option D, while it uses DirectQuery, does not align with the requirement for real-time access, which is best achieved with the 'Connect live' option.