Forum Discussion
Date value difference between SharePoint data source and power BI
Power BI only handles using UTC for data but SharePoint is possibly reporting the data in the +1 timezone.
SharePoint will record dates in it's database as a Date/Time by default, but for Midnight local time for the current date as per your SharePoint site's locale settings, it will convert that into a display friendly date only format on your sharepoint list, so daylight savings will cause havoc with this if you are trying to export this list data for use in anything else.
In Power Query, if you change the column to Date/Time. Does it show the previous day but 11pm or earlier? A bit of a awkward workaround is to add a Power Query step to set up a custom column to add a few hours to the date column, usually for the difference you see but may be worth adding 1 more hour as if you have daylight savings times in your locale, then in October this will happen again, but then format it back to Date Only in Power Query so you don't notice a difference.
Hi,
My SharePoint site settings seem to be fine. I don't have any issues with SharePoint data since it is showing correctly as 26-May-22 but in power BI it is showing as 25-May-22 which is wrong. Do you know how to change the timezone in Power BI
Power BI only handles using UTC for data but SharePoint is possibly reporting the data in the +1 timezone.
SharePoint will record dates in it's database as a Date/Time by default, but for Midnight local time for the current date as per your SharePoint site's locale settings, it will convert that into a display friendly date only format on your sharepoint list, so daylight savings will cause havoc with this if you are trying to export this list data for use in anything else.
In Power Query, if you change the column to Date/Time. Does it show the previous day but 11pm or earlier? A bit of a awkward workaround is to add a Power Query step to set up a custom column to add a few hours to the date column, usually for the difference you see but may be worth adding 1 more hour as if you have daylight savings times in your locale, then in October this will happen again, but then format it back to Date Only in Power Query so you don't notice a difference.
Situationally it may be easier to put appropriate time info into Sharepoint if using something like PowerApps as a front end. Ensure that your Sharepoint date column is set to Date AND TIME, and ensure the time is entered an hour or two past the default, which is midnight. When daylight saving kicks in and pulls it back by an hour, it will no longer be 23:00 the previous day. If you are using a date picker in PowerApps and Sharepoint as your back end, you can either set the hour to default to 2am or 3am in PA.. or you can change coding in the update field of the datacard to something like "DataCardValue34.SelectedDate + Time(Value("3"), Value("0"), 0)". Ensure your regional settings for everything is set to local. I appreciate this is unlikely to help the original poster, but may be helpful to anyone searching the Internet for solutions.