Forum Discussion
Helper IVIncremental Refresh - building historical model week by week
Hi unknown917,
If the parameters are not set up correctly, this issue will occur.
Ensure that your RangeStart and RangeEnd parameters are correctly named (case-sensitive) and have the Date/Time data type, not just Date.
If the issue persists, please share a screenshot of your parameter setup so we can identify any mistakes.FYI please refer below document,
Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn
If this post helps, then please consider Accepting as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Super UserTry this
let
// Replace with your table
Source = YourTable,
// Define the RangeStart and RangeEnd parameters dynamically
RangeStart = #datetime(), // Adjust the start date
RangeEnd = #datetime(), // Adjust the end date
// Filter rows based on the RangeStart and RangeEnd
FilteredRows = Table.SelectRows(Source, each [Date] >= RangeStart and [Date] < RangeEnd)
in
FilteredRows
Helper IVhello,
I have tried this, but when I attempt to set the incremental refresh, it says I haven't set up parameters yet...??
- Akash_Varuna
Ok , Could you set up parameters in power bi go to home tab manage parameters new parameters there you can set the start date and end date ie ranges then use those parameters
v-achippaCommunity Support
Hi unknown917,
We wanted to kindly follow up to check if the solution provided by Akash for the issue worked.
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Anjan Kumar Chippa
- v-achippa
Hi @unknown917,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by Akash for the issue worked.
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Anjan Kumar Chippa