Forum Discussion
Solved
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...
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')
Maybe check the Time difference between service and desktop. Power BI service works on UTC time and not local time.