Issue with Date whist taking data from sharepoint online list

[Nike_11]

Hey All, 

So I have a strange situation, where my power bi displays date differntly to what is registered in my sharepoint online list. Ive got the row, in column set for data and time, where it states that something was registered e.g. 24/01/2024. When transferring to PowerBi, I can see that my date is getting shifted to 23/01/2024. 

Is there something related to data config in Windows/sharepoint or where else would that be? 

BR

[lbendlin · Accepted solution]

Most likely your Sharepoint lives on UTC time (as it should). Handle the timezone difference as needed.

[v-yetao1-msft · Accepted solution]

Hi  @Nike_11 

 Power BI fetches the data in UTC format. This is what is causing the discrepancies you are seeing between SharePoint and Power BI. You need to add an adjustment in Power BI to convert the UTC time to the correct local timezone.

Coincidentally, I found a similar post that I hope will help you.

Power BI with Dates in Sharepoint Lists - UTC and ... - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Most likely your Sharepoint lives on UTC time (as it should). Handle the timezone difference as needed.