Date problem

[sky54000]

Hello everyone,

I just realized that I have a problem from the dates imported from my Sharepoint system into PowerBi software. The dates are modified by PowerBi without any actions on my side. PowerBi substract one or two hours on my dates.

For example, the first date on my screenshot should be 10/03/2018. I know that I am not the only one to face this issue. Is there any solution ? Not a workaround like creating a new column. Does anyone know why this is happening ?

[v-piga-msft]

Hi @sky54000,

By my tests with connecting the data with SharePoint Folder in Power BI Desktop, everything works as expected.

How do you conncet your data in SharePoint? List or Folder?

In addition, as HotChilli mentioned, this issue may caused by time zone, please check your time zone for power bi and the time zone for SharePoint is the same?

Best Regards,

Cherry

[sky54000]

Hi @v-piga-msft,

I connect my data in Sharepoint using the List connector.

How do I check the timezone of PowerBI ? I didn't found any parameters for the timezone in PowerBI software.

Sincerely yours,

Robin.

[v-piga-msft]

Hi @sky54000,

Based on this blog, we could use Now() to get the timezone.

Best Regards,

Cherry

[HotChilli]

Looks like the timezones of the source and powerbi don't match