Monthly semantic model refresh requires Power Automate, not scheduled refresh

Create and manage workspaces and assets
Answer Correct answer: C — only a Power Automate flow can trigger the refresh on the first day of each month; built-in scheduling stops at weekly.

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?

  1. a scheduled refresh
  2. an incremental refresh
  3. a Microsoft Power Automate flow Correct Answer
  4. an on-premises data gateway
monthly refresh power bi power automate refresh scheduled refresh intervals

Community Votes

A
56%
B
22%
C
22%

56% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

Power BI's built-in scheduled refresh offers only daily and weekly frequencies — Microsoft's refresh documentation explicitly says a monthly interval requires a Power Automate flow that triggers the dataset refresh.

Model1 with sales data must refresh on the first day of every month to include the previous month's sales, so the configuration must produce a monthly cadence.

Assuming scheduled refresh has a monthly option — the frequency dropdown stops at weekly, so picking scheduled refresh cannot meet a first-of-the-month requirement no matter how it is configured.

Community Discussion (5 comments)

Saiqua123 👍 2 Selected: C
pls correct me if i'm wrong, shouldn't it be C as per "Power BI does not have a monthly refresh interval option. However, you can use Power Automate to create a custom refresh interval that occurs monthly" //https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh#scheduled-refresh
0002110 👍 1 Selected: A
Scheduled Refresh: Purpose: Scheduled refresh is used to automate the process of refreshing the dataset on a regular basis, e.g., daily, weekly, monthly. Use Case: You can schedule the refresh to happen automatically on a specific date or time. In your case, you want to refresh the dataset on the first day of each month. This could be done using scheduled refresh
SylUK 👍 1 Selected: A
A is the answer : a scheduled refresh. In Power BI, "schedule refresh" means setting a recurring time to automatically refresh all data in a dataset, while "incremental refresh" only updates the new or changed data since the last refresh, allowing for faster updates on large datasets by avoiding unnecessary reloads of the entire data set. ( found on Google)
FazzieA 👍 2 Selected: B
The answer is correct as you cannot schedule refreshes to be once a month, the refresh frequency can be either daily or weekly. Incremental refresh will refresh the dataset for the last month with new data, the old data will not change.
Bildey 👍 3 Selected: A
  • a scheduled refresh While incremental refresh can help optimize the refresh process by refreshing only the data that has changed, it does not set the schedule for when the refresh happens. It helps with large datasets by minimizing data reloads, but it doesn’t solve the requirement of scheduling the refresh for the first day of each month.

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

Microsoft's data refresh documentation states plainly that Power BI does not have a monthly refresh interval option, and that you can use Power Automate to create a custom refresh interval, such as one occurring monthly. A Power Automate flow with a monthly trigger (first day) that invokes the refresh dataset action delivers exactly the required cadence, including last month's sales once the calendar month has closed.

Why the Other Options Are Wrong

A scheduled refresh (A) supports only daily and weekly frequencies, so it cannot fire on the first day of each month by design. Incremental refresh (B) controls which partitions of data are refreshed, not when or how often the model refreshes — it still rides on a daily or weekly schedule and offers no monthly trigger. An on-premises data gateway (D) is network plumbing for reaching on-premises sources; it has nothing to do with refresh timing, and no gateway is suggested by an Azure SQL source here.

Community Comment Notes

A commenter quotes the official documentation line that Power BI lacks a monthly refresh interval and recommends Power Automate for a custom monthly cadence, which is the decisive evidence. Comments favoring scheduled refresh describe daily and weekly scheduling and assert monthly support that the product does not have; one incremental-refresh comment concedes monthly scheduling is impossible while still voting for a refresh feature that cannot set the date.

Official Reference

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data

Related Analysis

You have a Microsoft Excel file in a Microsoft OneDrive fold

S-Grade

You have a Microsoft Power BI Desktop report named Report1 t

A-Grade

You create a report by using Microsoft Power BI Desktop. The

A-Grade

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide