You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a warehouse that has a table named Orders. You have a Microsoft Power BI semantic model in Power BI Desktop that sources data from the Orders table. You need to enable incremental refresh for the table. Which two parameters should you create?

Prepare for the DP-600 Fabric Analytics Engineer Exam. Study with flashcards and multiple choice questions, each offering hints and detailed explanations. Enhance your chances of success on the exam!

Multiple Choice

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a warehouse that has a table named Orders. You have a Microsoft Power BI semantic model in Power BI Desktop that sources data from the Orders table. You need to enable incremental refresh for the table. Which two parameters should you create?

Explanation:
Incremental refresh relies on a pair of dynamic date/time parameters that bound the data you refresh. These two parameters must be named RangeStart and RangeEnd, and they should be date/time types. In your query, you filter the table on the date column using those parameters (for example, DateColumn >= RangeStart and DateColumn < RangeEnd). The service then uses these two values to create partitions and refresh only the data within that window, keeping older data intact. The other parameter names don’t have special meaning to the incremental refresh feature, so they won’t drive the built‑in incremental behavior.

Incremental refresh relies on a pair of dynamic date/time parameters that bound the data you refresh. These two parameters must be named RangeStart and RangeEnd, and they should be date/time types. In your query, you filter the table on the date column using those parameters (for example, DateColumn >= RangeStart and DateColumn < RangeEnd). The service then uses these two values to create partitions and refresh only the data within that window, keeping older data intact. The other parameter names don’t have special meaning to the incremental refresh feature, so they won’t drive the built‑in incremental behavior.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy