Re: Date problem

sky54000 · ‎10-01-2018

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 · ‎10-01-2018

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

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

sky54000 · ‎10-02-2018

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 · ‎10-09-2018

Hi @sky54000,

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

Best Regards,

Cherry

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