Forum Discussion
Incremental refresh doubles my data
Hi,
I installed incremental refresh on a view, leading to this native query
And this report in Power BI Desktop (aantalRows = Number of Rows, AantalTrx = Number of Transactions)
This is my refresh strategy
When I install this in Power BI service, without refreshing, my report looks ok. But after the first (manual) refresh it looks like this
It deletes the row from 2018, which is correct. But why is it doubling the data on the first of February and March?
Regards
Ron
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 !
4 Replies
where 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 !
Anonymous usually happens when where the condition for range start and range end is not done correctly? How that has been set up?
✨ 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!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Hi parry2k
here it is
And this is the initial WHERE part
where [_].[Creation Datetime] >= convert(datetime2, '2015-01-01 00:00:00') and [_].[Creation Datetime] <= convert(datetime2, '2023-12-04 00:00:00')
