Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is this possible?
Hi @sjelting ,
Time Zone Differences:
Power BI Desktop and Power BI Service handle time zones differently.
In Power BI Desktop, the time zone is influenced by your local system settings, which is why you see the date in your locale timezone (3pm +01).
However, in Power BI Service, the time zone is always UTC. This means that regardless of where the data center hosting your Power BI tenant is located, the service will use UTC for all calculations and time-related functions.
Although Power BI Desktop adapts to the local time zone, the Power BI service always uses UTC To ensure accurate results, adjust your calculations accordingly.
Below is the link will help you:
Solved: timezone corrections on power BI service not the s... - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please be more specific. Refresh scheduling can be expressed in "local" timezones. But behind the scenes everything is always UTC.
Or do you mean something different?
I have a date in my database (2pm, UTC), which when i view it in PowerBI Desktop gets shown in my locale timezone (3pm +01), but if i publish it and refresh it via gateway, it is shown in PowerBI Service as 2pm, UTC.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |