Forum Discussion

DebbieK's avatar
DebbieK
Helper I
3 years ago
Solved

Sharepoint vs PowerBI Time Issues

I have a calendar of recurring events in Sharepoint, which I pull through into PowerBI. I recognise that there is a difference between the times displayed as PowerBI is working in UTC whereas Sharepo...
Need Help
  • DebbieK's avatar
    DebbieK
    3 years ago

    Hi amitchandak, further to my message above I think I have determined the cause. 

     

    Where the EventDate and the EndDate are on different sides of our daylight savings date, is where I am having the issue.

     

    Instead of allowing Sharepoint to use the "no end date" option for the recurring event which sets some arbitrary future date (in this case, which is over the daylight savings boundary), I can use the "End by" function to set my own distant future date which I can ensure is within the same daylight savings window.

     

    This ensures I return dates within the same time zone. 

     

    Thanks again for your support with references. 

DebbieK's avatar
DebbieK
Helper I
3 years ago

Hi amitchandak, further to my message above I think I have determined the cause. 

 

Where the EventDate and the EndDate are on different sides of our daylight savings date, is where I am having the issue.

 

Instead of allowing Sharepoint to use the "no end date" option for the recurring event which sets some arbitrary future date (in this case, which is over the daylight savings boundary), I can use the "End by" function to set my own distant future date which I can ensure is within the same daylight savings window.

 

This ensures I return dates within the same time zone. 

 

Thanks again for your support with references. 

v-yinliw-msft's avatar
v-yinliw-msft
Community Support
3 years ago

Hi DebbieK ,

 

Happy to hear you to find the solution of your question.

You can accept your answer as solution to let other people who have the same question with you find the answer easily.

 

Best Regards,

Community Support Team _Yinliw