Problem with Incremental Refresh after publish

[marukosu]

When I publish the report on service, and refresh the model, only data within the interval between RangeStart and RangeEnd continues to come.

Results on desktop:

Results on service after a five minutes refresh:

It's a ODBC query. I followed this video's instructions https://www.youtube.com/watch?v=x7q1DHf8wE4 and injected the date directly on query.

I carried out the same procedure in another report, with the difference that there the RangeStart was a much earlier date (01/01/2023). It brought the "historical data", due to this RangeStart, and then the incremental updates are working, as the time taken is very low.

Considering the settings below, in the first refresh to the Service, shouldn't the data already appear between 01/01/2019 and 05/30/2024?

[marukosu · Accepted solution]

Resolution: Incremental Refresh with Subqueries - Microsoft Fabric Community

🙏🙏🙏🙏🙏🙏🙏🙏

[GilbertQ]

Hi @marukosu 

Is the image you sent for the one that is called in the issue, or the one where it is working? I would potentially make sure to re-enable the incremental refresh and upload the PBIX again, and then go into the service and click on the refresh now button for your semantic model.

[marukosu]

The results prints are from the issue.

As for the other point, I already tried to overwrite and refresh, and also delete the model that was online, and upload it again, but it didn't help. Finally, I ended up putting 01/01/2023 in RangeStart so I could continue with my work. But I would like some help, because I understand that something is wrong.