SharePoint Date Data getting changed in Power BI

[anzil]

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

I need to get the accurate report. Please help

Below is my column settings and my timezone is Time zone in United Arab Emirates (GMT+4)

[AlexisOlson · Accepted solution]

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/

[v-yanjiang-msft]

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

[v-yanjiang-msft · Accepted solution]

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 _ kalyj

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

[AlexisOlson · Accepted solution]

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/