Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 148

You have a Power BI dataflow named DF1 that contains the following columns:

• OrderID
• SaleDate
• ProductID
• SalesAmount
• ProductCategory

You create a Power BI dataset named DS1 that uses DF1 as a data source. DS1 creates an aggregated view of the data in DF1. The view contains the following columns:

• SaleMonth
• SalesAmount
• ProductCategory

You need to minimize how long it takes to refresh DS1.

What should you do first?

Answer options

• A. Add a computed entity to DF1.
• B. Create a custom function in DS1.
• C. Create a linked entity in DF1.
• D. Add a computed column to DS1.

Correct answer: A

Explanation

Adding a computed entity to DF1 can help pre-aggregate or pre-calculate data, thus optimizing the refresh process for DS1. The other options, such as creating functions or columns in DS1, do not directly address the need to streamline the data processing in the source dataflow, which is crucial for reducing refresh time.