Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I've just realized of power bi service and desktop are representing different values from the same item....
For example I have created a new column to calculate working days
Laboral Day =
VAR EsFinDeSemana = Dates[Number Day] IN {7}
VAR EsFestivo =
RELATED(TablaFestivos[Fecha])
RETURN
IF (EsFestivo || EsFinDeSemana,0,1)
when I watch the result I have different values in desktop and service.
In desktop
In service:
Any idea ?
I already saw some post about utc time and GMT but I'mnot sure how to manage this....
Solved! Go to Solution.
Hi @Lburgos ,
This may be due to a discrepancy between the local time zone and the time zone corresponding to the service, please refer to:
Power BI Service Time Differences and How to Fix It (linkedin.com)
Re: Convert UTC to local time zone in DAX - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Lburgos ,
This may be due to a discrepancy between the local time zone and the time zone corresponding to the service, please refer to:
Power BI Service Time Differences and How to Fix It (linkedin.com)
Re: Convert UTC to local time zone in DAX - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.