Published report looks different!

Hi  Anonymous ,

Seeing that Today() is used in your function, it may be because the time and date of Power BI Desktop and Power BI Service are different.

Power BI Desktop uses the date and time of your computer's local time zone, while Power BI Service only supports date and time in UTC format.

If you punish your report with local timezone datetime values, it will convert your datetime values to UTC format and they may different than your desktop values.

You might consider using the dax function to add or subtract the difference between your timezone and UTC time.

For example:

Time = Now()-(8/24)

For more details, you can check the following link:

Solving DAX Time Zone Issue in Power BI

Daylight Saving Time And Time Zones In M

Page not found – Bond Consulting Services

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your reply Liu,

I ended up adding a refresh button which seemes to resolve the issue. what you suggested makes sense.

I think the Today() function messed up my report.

Thanks again