Forum Discussion
Incremental refresh and Group By in M/PowerQuery
Hi Anonymous,
Maybe you can try to create a new query to refer from the current query table and remove date field and grouping in new table, then cancel the loading of original query table. After these, the date fields should exist in the original table that not displayed.
Since the official document also not explain this cleanly, you can consider contacting to power bi team to know more about incremental refresh.
Regards,
Xiaxoin Sheng
Aw, seemed like a nice workaround, but when I do this, the loaded table doesnt let you set incremental refresh on it, because it doesn't contain the filtering steps on rangestart and end that incremental refresh requires.
I think for now I will just assume that Incremental refresh and group by statements that remove the datetime fields do not play nice together. It makes sense.
Jaap