Forum Discussion
Post PartisanDate Format from SharePoint List to Power BI
Hello
Thank you.
I was able to resolve the case.
I had to change the list settings in SharePoint.
The locale had to be set in the SharePoint List.
Wish you all the best.
Thank you for your support
Heinrich
Post PartisanHello
Sorry for the late reply.
I did that to and it didn't work.
There is a delta between SharePoint List and Power BI.
What I need to use version 1 for in Power BI
and add an additional Column with a formula who changes UTC to UTC+1/+2 (wintertime).
Regards
Heinrich
HI Heinrich,
You can manually choose on the ‘version 1’ API on the data connector toto getting data, then you can add a custom column to your query table side with DateTimeZone.SwitchZone function to switch the display DateTimeZone:
DateTimeZone.SwitchZone - PowerQuery M | Microsoft Learn
BTW, these datetimezone formats do not support on power bi data model table side so these changes will back to the common UTC format.
If you want to keep these, you need to manually change the datetime values on query editor side to add the timezone offset with raw datetime values.
Regards,
Xiaoxin Sheng