Forum Discussion
Data becomes incorrect after first incremental update
This is driving me crazy. I created a data model and incrementally updated the main table in fact.
When I update the data on the desktop the information is correct, when I publish it remains correct but after publishing the power bi service starts doing the first historical incremental update and when finished it specifically messes up this data:
Correct data on desktop
Wrong data after first incremental refresh
Native query is ok on all steps.
And I don't even get the warning that power by can't check whether query M is foldable, so it seems like everything is correct.
Does anyone have any suggestions.
Best regards.
Only one of the parameters can be inclusive, usually RangeStart. Change your formula to
select "_"."DTA",
"_"."VALOR"
from "CONSINCO"."PAS_TESTE" "_"
where "_"."DTA" >= to_date('2024-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "_"."DTA" < to_date('2024-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
5 Replies
Show your query. Most likely the RangeStart/RangeEnd filter is set incorrectly.
Maybe check the Time difference between service and desktop. Power BI service works on UTC time and not local time.
More information about the problem.
I isolated the values to see where specifically the problem was, I discovered that when PBI updates with the table configured for incremental, the first day of each month the value is duplicated as in the example below:
Without incremental first incremental refresh
After first incremental refresh
My native query:select "_"."ID_EMPRESA",
"_"."DATA",
"_"."ID_FILIAL",
"_"."CONTA",
"_"."NATUREZA",
"_"."HISTORICO",
"_"."VALOR",
"_"."CENTRO",
"_"."DTAEMISSAO",
"_"."USUINCLUSAO",
"_"."SEQFORNECEDOR",
"_"."VALORCAL"
from "CONSINCO"."PASV_PBI_LANCAMENTOS" "_"
where "_"."DATA" >= to_date('2024-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
and "_"."DATA" <= to_date('2024-04-19 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
EDIT:
I created a table in the database with 2 rows January 1 and February 1, with a value of 1000 and 2000, after an incremental refresh it duplicated the value.
Select on DBPBI after incremental refresh
Native Query:
select "_"."DTA",
"_"."VALOR"
from "CONSINCO"."PAS_TESTE" "_"
where "_"."DTA" >= to_date('2024-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "_"."DTA" <= to_date('2024-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')Only one of the parameters can be inclusive, usually RangeStart. Change your formula to
select "_"."DTA",
"_"."VALOR"
from "CONSINCO"."PAS_TESTE" "_"
where "_"."DTA" >= to_date('2024-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "_"."DTA" < to_date('2024-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')That was the problem! Thank you, I would never have imagined that!
