Forum Discussion

mnb's avatar
mnb
Frequent Visitor
7 years ago

SharePoint daylight saving time

Hello experts   Long term reader, first time poster!  I'm currently working on a couple of projects that pull data from SharePoint Online lists.  I'm able to pull all this thorugh to Power BI witho...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI mnb,

 

Maybe you can add a custom column in query editor with if statement to check current date time( if it in specific data range) and add offset.

 

In addition, you can also take a look at following blog:

Daylight Saving Time And Time Zones In M

 

Regards,

Xiaoxin Sheng

  • mnb's avatar
    mnb
    Frequent Visitor
    7 years ago

    Thanks for the reply Anonymous.  I can see how this would work for a manual refresh but once I deploy to the server and refresh the data there it will use the server time which as I understand it is UTC year round so there would be no impact.  Unless I've misunderstood?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      HI mnb,

       

      >>I can see how this would work for a manual refresh but once I deploy to the server and refresh the data there it will use the server time which as I understand it is UTC year round so there would be no impact.

      AFAIK, power bi service will convert datetime to UTC formula, it not support analysis by local timezone, you can take a look at following link to know more about this:

      Time in PBI Service is inconsistent with the local time (non-UTC time) displayed in PBI Desktop

       

      Regards,

      Xiaoxin Sheng