Check your knowledge

Completed

Answer the following questions to see what you've learned.

1.

You're responsible for the Dataverse environments for your organization, which is an online retailer. You set up an Azure Synapse Link for the data analysts. One analyst observes that the product category table isn't part of the available tables in a Power BI report that’s connected to Azure Synapse. How should you solve this issue?

Ask the analyst to refresh the data sources in Power BI.

Modify the Azure Synapse table list in the Azure portal to add the product category table.

Modify the Azure Synapse Link for Dataverse definition in the Power Apps portal to include the product category table.

2.

After you present a Power BI report that’s connected to a Dataverse data source, you share it with the members of the team who are attending the presentation. A colleague observes that the accessible version is drastically different than what you presented. What could be the reason for this difference?

The Dataverse connection setting is set as DirectQuery, and the security enforcement is restricting the records that your colleague has access to compared to what you can access.

The Dataverse connection setting is set as Import, and the security enforcement is restricting the records that your colleague has access to compared to what you can access.

The Dataverse connection setting is set as DirectQuery, and the refresh configuration hasn't been set to real-time for your colleague.

3.

You create a Power BI report that must be as current as possible based on a set of Dataverse tables that contain numerous records. Which type of data source should you use for this scenario?

A Dataverse connection that’s set as DirectQuery

A Dataverse connection that’s set as Import

Azure Synapse that’s linked to Dataverse

You must answer all questions before checking your work.