Forum Discussion
Incremental refresh doubles my data
Hi parry2k
Now the probem on first of Feb and March is solved.
WHERE clause =
where [_].[Creation Datetime] >= convert(datetime2, '2015-01-01 00:00:00') and [_].[Creation Datetime] < convert(datetime2, '2023-12-04 00:00:00')
After refreshing the visual also 2018 is not there. Thnx !
Super Userwhere condition is the problem, see image below from the increment refresh document. Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Docs
Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡
👉
✨
Anonymous
Hi parry2k
Now the probem on first of Feb and March is solved.
WHERE clause =
where [_].[Creation Datetime] >= convert(datetime2, '2015-01-01 00:00:00') and [_].[Creation Datetime] < convert(datetime2, '2023-12-04 00:00:00')
After refreshing the visual also 2018 is not there. Thnx !