Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Solved! Go to 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.
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
can they all be date type rather than date-time?
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.
You think this is specific? Wait until you learn about partitions and XMLA...
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.
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
RangeStart and RangeEnd need to be of DateTime type, not Date.
does the field in the relationship also need to be datetime?
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)) .
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
6 | |
2 | |
2 | |
2 |
User | Count |
---|---|
5 | |
4 | |
4 | |
3 | |
3 |