topic Cannot set up incremental refresh in Developer

Cannot set up incremental refresh

akasthan — Thu, 28 Oct 2021 18:59:13 GMT

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?

Re: Cannot set up incremental refresh

lbendlin — Sat, 30 Oct 2021 00:30:45 GMT

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

Re: Cannot set up incremental refresh

Anonymous — Tue, 02 Nov 2021 03:13:55 GMT

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

Re: Cannot set up incremental refresh

daviddodd64 — Thu, 23 Mar 2023 20:01:35 GMT

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.

Re: Cannot set up incremental refresh

lbendlin — Thu, 23 Mar 2023 21:04:20 GMT

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

Re: Cannot set up incremental refresh

strongCoreZach — Wed, 20 Sep 2023 19:13:29 GMT

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

Re: Cannot set up incremental refresh

strongCoreZach — Wed, 20 Sep 2023 19:28:15 GMT

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

Re: Cannot set up incremental refresh

lbendlin — Wed, 20 Sep 2023 19:58:09 GMT

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)) .