Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hey,
i have the problem. The Date in my sharepoint list is not the same in the PowerBi Desktop. Maybe in Sharepointlist its 23:00 then it is in PowerBi 00:00. Its depends everytime with the UTC.
How can i fix that ?
Solved! Go to Solution.
You can use the function DateTime.AddZone.
With the help of this function you can make a custom column that changes the UTC datetime value to your local time.
Just add a custom column with DateTime.AddZone([Columname], hours, minutes)
For example:
DateTime.AddZone([Columname], 2, 30)
this adds two hours and 30 minutes to the UTC time
You can use the function DateTime.AddZone.
With the help of this function you can make a custom column that changes the UTC datetime value to your local time.
Just add a custom column with DateTime.AddZone([Columname], hours, minutes)
For example:
DateTime.AddZone([Columname], 2, 30)
this adds two hours and 30 minutes to the UTC time
Hi @AlexTi
As PBI handles UTC time it's possible your SP is configured as per your timezone. You might need to fix the time in Power Query or change the time in the Desktop to match your SP time zone. Please see if the previous resolved post helps you.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
71 | |
63 | |
42 | |
28 | |
22 |