When I load a date from a SharePoint sheet into PowerBI, it gives me this date as a day older

[Anonymous]

Hello,

please, I have, for example, Date 13/8/2023 in a SharePoint list.
Now I need to pull this data into a PowerBI report, but it gives me this date as 12/8/2023.
Why does he do that? How can I fix it?

Thank you 🙂 

[Anonymous]

Hi @Anonymous,

What type of datetime values are you used? Did these include any local time zone information? AFAIK, normally the server will use the UTC format to store these datetime values. (remove the time zone offset may cause the missed part of date ranges)

Regards,

Xiaoxin Sheng

[Anonymous]

I am just inserting these values through PowerApps APP. Then it goes to SharePoint. 
This is the item in SharePoint with date 4.8:

But when I pull those datas into PowerBI its 3rd August.. What to do please? 

[Anonymous]

HI @Anonymous,

What version of power bi desktop are you worked on? I will test on the it to confirm if this related to specific version of powerbi desktop.

How to Get Your Question Answered Quickly 

In addition, please also take a look the the following link about UTC timezone and Daylight saving which may affect datetime values.

UTC vs Local Timezone, Daylight Savings for Power BI | by Susheel Aakulu | Medium

Regards,

Xiaoxin Sheng

[Anonymous]

well, it also happens when I upload the Date from Power App to Excel on OneDrive and same thing. I want to add 9.9.2023, I submit and send the information and when I open source Excel there is 8.8.2023 22:00 ... Why is this happening please? How to fix this ?