Incremental Refresh option not coming up when right clicking

[connormcp777]

Similar to this topic (https://community.fabric.microsoft.com/t5/Desktop/Incremental-Refresh-option-not-coming-when-right-c...) a few years ago, I cannot see the incremental refresh option when right clicking a table in PowerBI Desktop or Web. I have a Premium Subscription on a Premium Workspace. I am using PowerBI Version 2.150.2102.0 64-bit, so I shouldn't have any issues with an out-of-date version. Not to mention I can't open Incremental Refresh in the Web App either. Has it been moved?

[cengizhanarslan]

1) You Must Have RangeStart and RangeEnd Parameters

In Power BI Desktop(or Service as of Jan 26 update) → Manage Parameters, you need:

• RangeStart (Date/Time type)
• RangeEnd (Date/Time type)

Both must:

• Be DateTime

• Not text

• Not Date only

If they don’t exist, the Incremental Refresh option will not appear.

2) The Table Must Use Those Parameters in Power Query

In Power Query:

Your fact table must contain a filter like:

• [DateColumn] >= RangeStart and [DateColumn] < RangeEnd

3) Storage Mode Must Be Import

Incremental Refresh does NOT show for:

• DirectQuery
• Direct Lake

Only for Import models.

[kingoftheconnor]

The filter already exists here. Does this look sufficient?

It also is already in import mode

[Natarajan_M]

Hi @connormcp777 ,

Your table is in Direct query mode , not in Import mode .. incremental refresh works with import mode

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Direct query mode : 

import mode :

Thanks 

If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster

[kingoftheconnor]

Hello Natarajan! Thank you for the reply. From what I can tell it already is

[Natarajan_M]

Hi @kingoftheconnor , I hope you have the RangeStart and RangeEnd parameter and both of them in DateTime .

Thanks
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster

[kingoftheconnor]

Yes, I do. You can see the screenshots in the response to cengizhanarslan

[Natarajan_M]

Hi @kingoftheconnor  whats the data source of the Vw_ ?

thanks

[kingoftheconnor]

It is an Azure Database SQL Server. The vw_ is a view that joins on several tables.

[Natarajan_M]

Hi @kingoftheconnor , If the table is imported and the parameters are correctly defined, you should see the incremental refresh option. Can you right-click on the table and check again for the incremental refresh option?

Thanks 

[kingoftheconnor]

@Natarajan_M I just checked and it's still not available! Very strange.

[Natarajan_M · Accepted solution]

Hi @kingoftheconnor  , You cannot set up incremental refresh directly in the service. You need to open the .pbix file in Desktop to configure it.

Thanks
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster

[kingoftheconnor]

That did it! Thanks!