Forum Discussion
SharePoint Date Data getting changed in Power BI
I am developing a PowerBI report from SharePoint online list using powerBI desktop.
My report should give the task list according to the start date slicer. But I am getting some employees tasks on the selected date and
some employees tasks are the next day of the selected date.
for an example if i select 20.11.2021, report giving some employees tasks on 20.11.2021 and some of 21.11.2021
Below is my column settings and my timezone is Time zone in United Arab Emirates (GMT+4)
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/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.
3 Replies
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/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.
Hi anzil ,
Did my solution solve your problem? If yes, please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ kalyj