Cannot set up incremental refresh

[akasthan]

Hi PowerBI Community,

I am not able to set up an incremental refresh as shown in the Power BI walkthrough  (https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview)

I have created the parameteres and filtered the data using the parameters but when I right click on the table and select "Incremental Refresh" all of the options are greyed out. (See first image below) It says that I need to set up parameters but I have already did that. (see second image below)

Unlike this post I have kept the parameter name as RangeStart and RangeEnd only but still the slider to turn on incremental refresh is greyed out. The data source here in this case is Azure Data Lake Storage Gen1.

Can someone help me enabling incremental refresh?

[strongCoreZach]

can they all be date type rather than date-time?

[daviddodd64]

It is absurd that we must be so specific in order to use this feature. Microsoft really needs to work on its Power Apps. It shouldn't be this difficult to use basic features - or to find specific enough documentation.

[lbendlin]

You think this is specific? Wait until you learn about partitions and XMLA...

[Anonymous · Accepted solution]

Hi @akasthan ,

Please change the data type of both the parameter RangeStart&RangeEnd and the date field in your fact table as Date/Time in Power Query Editor just as suggested by @lbendlin. You can review the content in the following link for the details.

Create parameters

Change the date type of parameter RangeStart and RangeEnd as Date/Time

Change the date field in fact table as Date/TimeAfter completed the above steps, you can configure incremental refresh normally...

Best Regards

[lbendlin]

RangeStart and RangeEnd need to be of DateTime type, not Date.

[strongCoreZach]

does the field in the relationship also need to be datetime?

[lbendlin]

The RangeStart and RangeEnd parameters must be datetime or dateinteger.  What is dateinteger do I hear you ask?

Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

The format of your actual column for partition control doesn't matter, but it must be transformable into the format used by the parameters during the query, and must be usable for partition control. So for example if you had a numeric column [z] with values from 1 to 6 you could use DateTime.From(#date(2023-[z],1,1)) and DateTime.From(#date(2024-[z],1,1)) .