Dynamic Parameter for refresh

Hi SurfingData ,

It looks like you need to use incremental refresh, and in a refresh scenario this feature is more suitable for you.

Incremental Refresh and Hybrid tables in Power BI: Load Changes Only - RADACAD

When configuring incremental refresh in Power BI Desktop, you first create two Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd. These parameters, defined in the Manage Parameters dialog in Power Query Editor are initially used to filter the data loaded into the Power BI Desktop model table to include only those rows with a date/time within that period. After the model is published to the service, RangeStart and RangeEnd are overridden automatically by the service to query data defined by the refresh period specified in the incremental refresh policy settings.

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ Caitlyn

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