Forum Discussion
incremental Refresh sends weirds range calls
I don't think that works for "My Workspace". Try with a proper shared workspace.
RangeStart -> used as GTE param sent to server
RangeEnd -> used as TLE param sent to server
On the server its allow only GTE and TLE, not GT and TL. Why is it important?
If both RangeStart and RangeEnd are inclusive then you risk duplicating data in adjacent partitions.
how its takes the setting I've enter in Power BI Desktop (2 years archive, 1 day before refresh) and using it when I perform refersh on Power BI Service
1. You specified 2 years for archive. That means the Power BI service will create partitions for each calendar year in that range, meaning this can be up to three partitions, not just the two you think you specified.
2. You specified 1 day for refresh. That means a couple of things. First of all, you will see up to 32 daily partitions. Then (because of 1.) you will see that the Power BI Service is consolidating these daily partitions into monthly, quarterly and yearly partitions (all in calendar terms). This is done for you automatically. And secondly if you use an XMLA query tool you can see the last refresh date for each partition so you can confirm that you your newest daily partition is indeed the only one that got touched (except for consolidation days).
