nerdexam
Microsoft

PL-300 · Question #77

You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users

The correct answer is A. Deploy an on-premises data gateway. Connect to the data by using the Connect live option.. To provide current data from an on-premises SSAS tabular database to a shared Power BI dashboard, deploy a standard on-premises data gateway and use the 'Connect live' option.

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

Question

You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization. The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data. 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?

Options

  • ADeploy an on-premises data gateway. Connect to the data by using the Connect live option.
  • BDeploy an on-premises data gateway. Connect to the data by using the DirectQuery Data
  • CDeploy an on-premises data gateway (personal mode). Connect to the data by using the Connect
  • DDeploy an on-premises data gateway (personal mode). Connect to the data by using the

How the community answered

(27 responses)
  • A
    81% (22)
  • B
    11% (3)
  • C
    4% (1)
  • D
    4% (1)

Why each option

To provide current data from an on-premises SSAS tabular database to a shared Power BI dashboard, deploy a standard on-premises data gateway and use the 'Connect live' option.

ADeploy an on-premises data gateway. Connect to the data by using the Connect live option.Correct

For connecting to an on-premises SQL Server Analysis Services tabular database from the Power BI service, a standard on-premises data gateway is required to bridge the secure connection. The 'Connect live' option establishes a direct, real-time connection to the SSAS model, allowing Power BI reports and dashboards to query the model on demand and always display the most current data.

BDeploy an on-premises data gateway. Connect to the data by using the DirectQuery Data

While DirectQuery is a general concept for live connections, for SSAS, the specific option in Power BI is 'Connect live,' and the terminology 'DirectQuery Data Connectivity mode' is primarily used for relational databases.

CDeploy an on-premises data gateway (personal mode). Connect to the data by using the Connect

An on-premises data gateway (personal mode) cannot be shared with other users in the organization, failing the 'shared between the users' requirement for the dashboard.

DDeploy an on-premises data gateway (personal mode). Connect to the data by using the

Similar to C, connecting with a personal mode gateway is not suitable for sharing across an organization, regardless of the connectivity type used.

Concept tested: Connecting to SSAS, on-premises data gateway types, and live data

Source: https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-ssas

Topics

#On-premises data gateway#Live Connection#SSAS Connectivity#Data Freshness

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice