PL-300 · Question #78
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…
The correct answer is A. Deploy an on-premises data gateway and configure the connection to SalesDB to use the. To ensure a Power BI report published to the service accesses current data from an on-premises SSAS tabular database, deploy a standard on-premises data gateway and configure a 'Connect live' connection.
Question
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?
Options
- ADeploy an on-premises data gateway and configure the connection to SalesDB to use the
- BDeploy an on-premises data gateway and configure the connection to SalesDB to use the Import
- CDeploy an on-premises data gateway (personal mode) and configure the connection to SalesDB
- DDeploy an on-premises data gateway and configure the connection to SalesDB to use the
How the community answered
(42 responses)- A76% (32)
- B7% (3)
- C2% (1)
- D14% (6)
Why each option
To ensure a Power BI report published to the service accesses current data from an on-premises SSAS tabular database, deploy a standard on-premises data gateway and configure a 'Connect live' connection.
Deploying a standard on-premises data gateway enables the Power BI service to securely connect to the on-premises SSAS tabular database (SalesDB). The 'Connect live' option establishes a direct, real-time connection, ensuring that the report always queries the SSAS model for the most current data when viewed in the Power BI service.
The Import Data Connectivity mode loads data into Power BI, requiring scheduled refreshes, which means the data would not be 'current' at all times without a manual or scheduled refresh.
An on-premises data gateway (personal mode) cannot be used for reports published to the Power BI service for organizational access; it is designed for individual use only.
The option text is cut, but it likely refers to an incorrect connection mode or gateway type that would not meet the requirement for current data access for published reports.
Concept tested: Power BI gateway for SSAS, data connectivity modes
Source: https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-ssas
Topics
Community Discussion
No community discussion yet for this question.