Solved: "Today" date is ok in desktop but wrong when publi...

MCastellano · ‎01-31-2022

I have a report with a card showing current date (Feb 2022) in Power Bi desktop. When I refresh, publish and update the app it shows the wrong date (Jan 2022). Why is that?

On Power BI Desktop

When updating app after saving and publishing on deskptop

Any ideas? Thanks in advance

mahoneypat · ‎02-01-2022

The service uses UTC time and you must have refreshed when UTC was a different day (and month). You can add/subtract hours in your expression as needed to address the time difference.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

MCastellano · ‎02-06-2022

Thanks Pat.

mahoneypat · ‎02-01-2022

The service uses UTC time and you must have refreshed when UTC was a different day (and month). You can add/subtract hours in your expression as needed to address the time difference.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube