Forum Discussion
incremental refresh query trace
Hi, i setup incremental refresh on a power bi file to refresh incrementally using detect data changes option against a SQL Server database. I ran the initial load and then a refresh and when i do ...
Hi scabral ,
For the Incremental refresh, there are two Power Query date/time parameters RangeStart and RangeEnd, and it will only filter the changed data between the two parameters. So you may check if the datetime that is related to the top 1000 rows data is during the RangeStart and RangeEnd. Or you may change the values of parameters RangeStart and RangeEnd to test the returned data rows.
For reference:
Incremental refresh in Power BI
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.