Reply
dtran
Helper II
Helper II
Partially syndicated - Outbound

Incremental refresh can not toggle to ON

Hi,

Need help to understand why I can't toggle Incremental refresh to ON.

-Power BI Desktop 2.79

-Power BI Pro

 

Followed the official documentation to set up the parameters for RangeStart and RangeEnd. 

Here my screenshots for them.

RangeStartRangeStartRangeEndRangeEnd

 

 

Here is my Filter Rows screenshot:

Filter RowsFilter Rows

 

When I get to the Incremental refresh screen, I can't toggle the button to ON.

Incremental refresh can not toggle to ONIncremental refresh can not toggle to ON

Please advise! 

Thank you in advance!

 

Dennis

 

 

2 ACCEPTED SOLUTIONS

Syndicated - Outbound

@dtran 

 

Parameter names should be "RangeStart" and "RangeEnd" and its type should be Date/Time, not just Date.



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂


Regards,
Nandu Krishna

View solution in original post

v-kelly-msft
Community Support
Community Support

Syndicated - Outbound

Hi @dtran

 

Yes, as suggested by @nandukrishnavs ,type for Parameter should be Date/Time, not just Date.Besides you should have a date/time column in your original table to be filtered by parameter.

Here is the reference.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

6 REPLIES 6
v-kelly-msft
Community Support
Community Support

Syndicated - Outbound

Hi @dtran

 

Yes, as suggested by @nandukrishnavs ,type for Parameter should be Date/Time, not just Date.Besides you should have a date/time column in your original table to be filtered by parameter.

Here is the reference.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
amitchandak
Super User
Super User

Syndicated - Outbound

@dtran , have you loaded data once? There is a date column in the table ?

 

Refer:https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Syndicated - Outbound

@amitchandak 

 

-What do you mean "loaded data once"? 

-The date column is date_key in my_table.

 

 

Syndicated - Outbound

@dtran 

 

Parameter names should be "RangeStart" and "RangeEnd" and its type should be Date/Time, not just Date.



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂


Regards,
Nandu Krishna

nandukrishnavs
Super User
Super User

Syndicated - Outbound

@dtran 

 

You are using RangeStart instead of RangeEnd. Please verify that.

 

filter-rows

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂


Regards,
Nandu Krishna

Syndicated - Outbound

@nandukrishnavs 

Apologoes...this is the correct screenshot. I'm using RangeEnd in the bottom parameters

filter rowsfilter rows

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)