Forum Discussion
Cannot setup incremental refresh parameters
I have both RangeStart and RangeEnd copypasted from here:
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#configure-incremental-refresh-and-real-time-data
to make sure there was no typing mistake. Types of both set to date/time, values are valid date/times. Fact table date column has type date/time, too. Yet I'm getting that message that parameters need to be set up. What am I doing wrong?
You should filter the data using the new params as in the following section in the same doc you shared above: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#filter-data
Have you tried that?
If this is a semantic model in Power BI Desktop you need to now add the filter to your query using these parameters. NOTE: RangeStart is inclusive and RangeEnd is exclusive.
If this is a dataflow then the filter will be added for you.
Hi,Greg_Deckler ,lbendlin and omalbluw ,thanks for your concern about this issue.
Your answers are excellent!
And I would like to share some additional solutions below.
Hello,eugene_novikov .I am glad to help you.
This is my test:
Setup ParametersSelect the date field you need to filter (the system will set up partitions for the table based on the data in this field for incremental refreshing)
Select RangeStart and RangeEnd to create a parameter filter.
The range of the filter must exist in one open interval and one closed interval
(there must and can only be one "equal to" )After filtering forms with parameters set, the system automatically monitors forms that can be set for incremental refreshing.
If you want to realize incremental refresh, you must meet the following conditions.
1. The data source supports query folding.
If your data source does not support query folding, you can try inserting the M function in the power query
Query folding on native queries - Power Query | Microsoft Learn
Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn
2. the existence of date / time type table (or can be converted to date / time type of the function of the type of digital type) of the data columns, and successfully set the range parameter
3. Successfully set the incremental refresh strategy.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
You should filter the data using the new params as in the following section in the same doc you shared above: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#filter-data
Have you tried that?
eugene_novikov Did you make sure to save and close Power Query Editor? Apply the changes that is?
If this is a semantic model in Power BI Desktop you need to now add the filter to your query using these parameters. NOTE: RangeStart is inclusive and RangeEnd is exclusive.
If this is a dataflow then the filter will be added for you.
Hi,Greg_Deckler ,lbendlin and omalbluw ,thanks for your concern about this issue.
Your answers are excellent!
And I would like to share some additional solutions below.
Hello,eugene_novikov .I am glad to help you.
This is my test:
Setup ParametersSelect the date field you need to filter (the system will set up partitions for the table based on the data in this field for incremental refreshing)
Select RangeStart and RangeEnd to create a parameter filter.
The range of the filter must exist in one open interval and one closed interval
(there must and can only be one "equal to" )After filtering forms with parameters set, the system automatically monitors forms that can be set for incremental refreshing.
If you want to realize incremental refresh, you must meet the following conditions.
1. The data source supports query folding.
If your data source does not support query folding, you can try inserting the M function in the power query
Query folding on native queries - Power Query | Microsoft Learn
Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn
2. the existence of date / time type table (or can be converted to date / time type of the function of the type of digital type) of the data columns, and successfully set the range parameter
3. Successfully set the incremental refresh strategy.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.#1 is not a hard requirement. Desirable yes, required no.
