Forum Discussion
SharePoint Date Data getting changed in Power BI
- 4 years ago
I'm guessing there's a timezone mismatch. This may be useful to you:
https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/ - 4 years ago
Hi anzil ,
By my research, there’re two ways you can have a try to fix it.
A.change the API version for the SharePoint source in Advanced editor from 15 to 14.
B.1. Go to 'Edit Query' in your Power BI file and change the type of the date column to Date/Time/Timezone.
2.Change Date & Time Column, Time to Local Time.
3.Change Data Type to Date/Time to remove the Timezone.
Reference: Solved: Re: SharePoint Date Data getting changed in Power ... - Microsoft Power BI Community
Re: SharePoint date differs from Power BI date - Microsoft Power BI Community
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm guessing there's a timezone mismatch. This may be useful to you:
https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/