Which methods should you use?

HOTSPOT

You are creating a capacity planning dashboard with Power BI desktop.

The dashboard must be able to be used within a model-driven manufacturing planning app as well as be embedded within a Microsoft Teams channel.

The data sources are as follows:

You need to determine the appropriate method for accomplishing each task.

Which methods should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: Use a Date Gateway

You can install an on-premises data gateway on the same local computer as SQL Server (in production, it would typically be a different computer).

Box 2: Create an entity relationship in CDS Solution Explorer You can create relationships with CDS Solution Explorer.

Box 3: Create an aggregate table

Rollup columns help users obtain insights into data by monitoring key business metrics. A rollup column contains an aggregate value computed over the rows related to a specified row. This includes regular tables and activity tables such as emails and appointments.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/define-rollup-fields