Microsoft Power BI Data Analyst — Question 46

You have a Power BI semantic model named Model1 that contains sales data.

You need to ensure that Model1 is refreshed on the first day of each month to include last month’s sales data.

What should you configure?

Answer options

• A. a scheduled refresh
• B. an incremental refresh
• C. a Microsoft Power Automate flow
• D. an on-premises data gateway

Correct answer: C

Explanation

The correct answer is C, as a Microsoft Power Automate flow can be used to automate the refresh process on a specified schedule, including the first day of each month. A scheduled refresh (A) does not allow for such specific timing configurations, while an incremental refresh (B) is focused on updating only data that has changed rather than performing a full refresh. An on-premises data gateway (D) is essential for accessing on-premises data but does not handle the scheduling of refreshes on its own.