Forum Discussion
incremental refresh issue in PowerBI
Hi All, I am trying to implement the incremental rfresh in PowerBI and having some issues The source of my data is SQL server. I have imported few tables from the SQL Server. I have then cr...
Hi Anonymous
The incremental refresh must conform the following rules:
1.Date filtering- the types of parameters(RangeStart and RangeEnd) must be "Date/Time" and the filtered column type should be "Date/Time" or integer data type
2.Query folding - Incremental refresh is designed for data sources that support query folding.
You can refer to the following links:
Incremental Refresh and Hybrid tables in Power BI: Load Changes Only - RADACAD
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ppm1
Solution Sage
Solution SageNote that RangeStart and RangeEnd must be DateTime type (not Date). Once that is the case, you likely need to wrap them with Date.From( ) in your Filter step.
Pat