Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Incremental refresh is not working with Dataverse even when the query folding is enabled. Even when the record is deleted that falls outside of the date range, record is not seen in the power query and performing full refresh.
Incremental refresh is not working with Dataverse even when the query folding is enabled. Even when the record is deleted that falls outside of the date range, record is not seen in the power query and performing full refresh.
filter parameters RangeStart and RangeEnd have been used in the Power Query.
for the first issue you will want to confirm that your Power Query code includes a filter command that uses both RangeStart and RangeEnd.
The second issue is more complex. What you need is differential refresh, not incremental refresh. As a workaround you need to increase the update window.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |