Advanced incremental refresh via API - All 'OTHER' tables

Hi ajohnso2 ,

Based on the information you provided, when a refresh is triggered via the API to apply an incremental refresh policy and effective date, the action will target the table specified in the body of the request. The refresh behaviour for the rest of the model depends on how the dataset and its tables are configured in Power BI. To achieve your goal consider the following:

1. your current script is the correct way to apply an effective date to an incremental refresh. For tables that do not have an incremental refresh strategy, a full refresh operation will reload the entire table's data from the source.

2. ensure that your dataset is configured correctly in Power BI Desktop before publishing. Tables that require frequent updates should have an incremental refresh policy defined, while static or slow-changing tables do not require such a policy.

3. After adjusting the refresh script or dataset configuration, test the refresh operation to ensure that it behaves as expected.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.