Forum Discussion
[Bug] Pipeline deployment messes up calculated dates
Hi everyone,
I am using PowerBI Service and Pipelines for a moment, but I never encountered a bug like that one.
Basically, I have a table with dates, and a custom calculated column giving me the current week that looks like that:
Filter Year+Week =
IF (
'Table_Dates(onlyMonday)'[Year] = YEAR ( TODAY () )
&& 'Table_Dates(onlyMonday)'[ISO Week Number] = WEEKNUM ( TODAY (), 21 ),
"Current",
CONVERT (
( ( 'Table_Dates(onlyMonday)'[ISO Year] * 100 ) + 'Table_Dates(onlyMonday)'[ISO Week Number] ),
STRING
)
)
Everything works like intended in desktop and in my dev workspace once I publish it.
I also inserted UTCNOW() for debugging pusposes.
Dev workspace
But once I deploy in Test (or Prod) workspace through the pipeline, I have my calculations that are off, even after refreshing all sources:
test
Does anyone have any idea why? I never had an issue similar and it looks like the pipeline somehow messes up my calculated columns.
Thanks
4 Replies
- lbendlin
Super User
I have seen similar in the latest Power BI Desktop (August 2022 CFE1) where a date of "2022-01-01" would yield "December" when called with FORMAT([Date],"mmmm") . Wonder if that is related.
- benceNew Member
Hello,
Not sure it is directly related, but there is something weird about the dates in the August version. I have trouble understanding how my dev and test datasets can compute different results with the same formula- lbendlin
Super User
Definitely. And QFE1 has not addressed these issues yet.
- LeeBenjamin
Microsoft Employee
Please open a ticket if this issue is still relevant, so we could investigate further.
Thanks you,
Lee