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.
Please note that I have just three rows of dummy data