Forum Discussion
Incremental refresh messing up with query calculation
Hi all,
struggling with Incremental refresh behavior again...
Part of the query that acts weirdly:
#"GroupedData" = Table.Group(#"Removed Columns", {"customer", "fiscper"},
{
{"MaxCalday", each List.Max([calday]), type date}
}
),
#"MergedData" = Table.Join(#"Removed Columns", {"customer", "fiscper", "calday"}, GroupedData, {"customer", "fiscper", "MaxCalday"}),
In PBI Desktop works properly:
But once published, in PBI Service from some reason feb 26th appears:
This does not happen a lot but happens enough that the report is not correct.
Is there something I am missing?
Acts the same way whether I set the refresh to last 10 days or last 1 month or last 4 months.
Thank you!
9 Replies
I don't see the Incremental Refresh connection to your query. Please clarify.
Sorry, missed to explain that part.
When I publish the report without incremental refresh setup (so, just whatever is in the startdate-enddate range), it works and calculates properly.
The random surpluss dates show when I publish the report with incremental refresh, this setup:
Data is sourced from Azure Databricks, if it makes difference.Show the part of your Power Query that applies the filters.
NOTE: RangeStart must be inclusive, RangeEnd must be exclusive (or the other way round). They cannot both be inclusive.
