Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
BShirer4
Frequent Visitor

Incremental Refresh Issue - Parameter seletion no longer an option when creating Range filter

I am having an issue setting up Incremental Refreshes on a semantic data model, and I have done this before and I am aware that the RangeStart and RangeEnd must be of date/time as well the column of the table that I am trying to apply the custom filter to.

When I've done this before, there was an option to use parameters or calendars between the "Date filters" dialog box in Power BI (where you can select items like "is on", "is on or after", "is before") and the calendar date selector box.

The option to use parameters seems to be missing:

BShirer4_0-1743680734940.png


I've checked, and rechecked, and both the parameter and the column are date/time types (not just date) and the parameter values are valid datetimes.

Confused as how I got this running in the past, I've opened numberous PBIX files that were created in the Desktop App over a year ago.  These PBIX models are curently running in production using the incremental refresh option.  When I go into these older PBIX files that are running, and I try to edit the Custom filter there, the option to select a parameter is no longer avialable.

Can anyone think if I am missing something? This was obviously set up properly before, but for some reason I am unable to use parameters in the custom filters for new or old semantic models.  Is there some trick I am missing to turn that calendar selector to a parameter selector?  At work, I am using the Feb 2025 release, and I also tried this at home using March 2025, with the same results.

Thank you all.

1 ACCEPTED SOLUTION
BShirer4
Frequent Visitor

I think I finally found my issue...  I remembered setting this up in Power BI Desktop, but it looks like it is available in Power Query Editor, which is what the instructions specified.  I'm sorry for the confusion.

View solution in original post

6 REPLIES 6
v-csrikanth
Community Support
Community Support

Hi @BShirer4 
Thank you for being part of the Microsoft Fabric Community.
As mentioned above that you have resolved your issue on through research.
Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Best Regards,
Community Support Team _ C Srikanth.  

BShirer4
Frequent Visitor

I think I finally found my issue...  I remembered setting this up in Power BI Desktop, but it looks like it is available in Power Query Editor, which is what the instructions specified.  I'm sorry for the confusion.

lbendlin
Super User
Super User

that dialog looks very different from mine.  Is that in a dataflow Gen2 maybe?

 

lbendlin_0-1743686281796.png

 

What you are showing in your image is what I used to see in the Power BI Desktop App.  There is an option to select an actual date or a Parameter.   I've lost the ability to choose parameters - even on PBIX files that had incemental refrehses set up and running.

The image I shared was from the Power BI Desktop Application.  Here is a full screen shot of the desktop app, trying to create a custom filter:

 

BShirer4_0-1743688992463.png

 

You are in the Power BI view. There the parameters are not accessible unless you have enabled load. 

 

Click on "Transform Data".

@lbendlin, thank you for your response.
I had tried with both enable load and not enabling load.  In the image below, I enabled load (you can see the param as tables now), but am still unable to select them when making a custom filter:

BShirer4_0-1743700747016.png

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.