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.
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)- A81% (22)
- B11% (3)
- C4% (1)
- D4% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.