Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
TonyChang
New Member

Configure incremental refresh and real-time data issue

I have tried to explain and setup the configuration incremental refresh and live data for Power BI dataset based on the following link

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

 

Step 1: Create parameters such as RangeStart and RangeEnd as used in the demo. 

Step 2: Refresh data starting at RangeStart and RangeEnd. 

Step 3: Don't see any functionality to define a policy, 

Due to the use of incremental refreshes, the problem always occurs as shown in the figure below. 

TonyChang_0-1692155522215.png

 

TonyChang_1-1692155546204.png

 

1 ACCEPTED SOLUTION

Hi , @TonyChang 

According to your description, when you configure the incremental refresh , you encounter the error code when you configure the policies for the table .

For your issue, you need to check if you meet the prerequisite for incremental refresh .

(1)You need to connect the data with import mode .

(2)Incremental refresh and real-time data works best for structured, relational data sources like SQL Database . The data source need to support the Query folding .

For more information, you can refer to :
Query folding - Power Query | Microsoft Learn

 

(3)You need to check the parameter the "RangeStart and RangeEnd" is totalty the same .

Because these two parameters need to be overridden to send requests to the data source during incremental refresh.

 

(4)You need to check that your Date column is of type Date/Time (not Date); and that the Date column is properly FIltered.And check whether the parameter type is correct "Date/Time".

vyueyunzhmsft_0-1692325949225.pngvyueyunzhmsft_1-1692325975976.png

 

And you can also see if you meet the prerequisite  for the incremental refresh in this :
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

 

And you can also see how to configure the incremental refresh by this viedo:
Configuring Incremental Refresh in Power BI - Bing video

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

View solution in original post

2 REPLIES 2
TonyChang
New Member

Sorry, Update my Power BI Desktop version: 

TonyChang_0-1692158356808.png

 

Hi , @TonyChang 

According to your description, when you configure the incremental refresh , you encounter the error code when you configure the policies for the table .

For your issue, you need to check if you meet the prerequisite for incremental refresh .

(1)You need to connect the data with import mode .

(2)Incremental refresh and real-time data works best for structured, relational data sources like SQL Database . The data source need to support the Query folding .

For more information, you can refer to :
Query folding - Power Query | Microsoft Learn

 

(3)You need to check the parameter the "RangeStart and RangeEnd" is totalty the same .

Because these two parameters need to be overridden to send requests to the data source during incremental refresh.

 

(4)You need to check that your Date column is of type Date/Time (not Date); and that the Date column is properly FIltered.And check whether the parameter type is correct "Date/Time".

vyueyunzhmsft_0-1692325949225.pngvyueyunzhmsft_1-1692325975976.png

 

And you can also see if you meet the prerequisite  for the incremental refresh in this :
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

 

And you can also see how to configure the incremental refresh by this viedo:
Configuring Incremental Refresh in Power BI - Bing video

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.