Date Issue - BI Changing Date Value

Hi  denney103184 ,

In these threads, they talked about it for the following reasons:

https://community.powerbi.com/t5/Desktop/SharePoint-date-differs-from-Power-BI-date/td-p/13856

One possible cause is :

dates in the summer were changing to the previous day because an hour was being taken off due to daylight saving

Solution:

set the imported column to data type timezone and create a new calculated column based on it with a data type date;

Another may be: ApiVersion

Solution : Change to ApiVersion14

You can also try the following:

1. Enter the Power query and select the date column.

2. Select the date columns, Right Click --Change Type - Using Locale.

3. Select in Data Type: Date and Set the Locale (in your case you can use English - United States).

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Date-1-day-behind-source-date/td-p/1349057

https://community.powerbi.com/t5/Desktop/Import-sharepointlist-Wrong-date-offset-1-day/td-p/1135678

https://community.powerbi.com/t5/Desktop/SharePoint-Date-Data-getting-changed-in-Power-BI/td-p/736429

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.