Forum Discussion
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.
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".
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 LearnAnd you can also see how to configure the incremental refresh by this viedo:
Configuring Incremental Refresh in Power BI - Bing videoThank 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
2 Replies
Sorry, Update my Power BI Desktop version:
- v-yueyunzh-msft
Community Support
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".
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 LearnAnd you can also see how to configure the incremental refresh by this viedo:
Configuring Incremental Refresh in Power BI - Bing videoThank 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
