nerdexam
Microsoft

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.

Submitted by yuriko_h· Apr 18, 2026Manage and secure Power BI

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)
  • A
    76% (32)
  • B
    7% (3)
  • C
    2% (1)
  • D
    14% (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.

ADeploy an on-premises data gateway and configure the connection to SalesDB to use theCorrect

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.

BDeploy an on-premises data gateway and configure the connection to SalesDB to use the Import

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.

CDeploy an on-premises data gateway (personal mode) and configure the connection to SalesDB

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.

DDeploy an on-premises data gateway and configure the connection to SalesDB to use the

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

#On-premises data gateway#SSAS connection#DirectQuery / Live Connection#Power BI Service connectivity

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice