Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have no idea if this is SharePoint, PBI desktop or the service.
Issue:
Decided to repeat the whole process, but now when I am in Desktop the DataTime is showing in UTC (step 3). For the life of me cannot get anything to show in local. Tried changing datetime local etc... Nothing is working.
Can anyone help, or is anyone having the same issues.
Many thanks
Solved! Go to Solution.
@tanyad
In desktop, now() function returns the local time, when you publish to service the now() function will return the UTC time. Unfortunately, We can't change the the time zone on Power BI Service.
To get time zone correct, you can add or reduce the time difference in dax, or change the timezone in power query. For detail: Solving DAX Time Zone Issue in Power BI.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@tanyad
In desktop, now() function returns the local time, when you publish to service the now() function will return the UTC time. Unfortunately, We can't change the the time zone on Power BI Service.
To get time zone correct, you can add or reduce the time difference in dax, or change the timezone in power query. For detail: Solving DAX Time Zone Issue in Power BI.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@tanyad , Refer if this can help
https://sharepoint.stackexchange.com/questions/264660/sharepoint-date-wrong-in-power-bi
https://community.powerbi.com/t5/Desktop/Time-Zone-Issue/td-p/646902
Many thanks for the pointers, however when i originally built the report on the 22nd June i did not have to convert anything, i just consumed the data into a Dataflow, which then showed it as UK. What i am wondering is what has changed in the Service in the last week or so that has changed how it handles the dates.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
98 | |
96 | |
87 | |
68 |
User | Count |
---|---|
167 | |
134 | |
129 | |
103 | |
96 |