Forum Discussion
Sharepoint vs PowerBI Time Issues
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.
Hi amitchandak, thanks for those references.
I have changed the field type to display timezone and it has given me further information that for some reason the EndDate is in a different timezone to the EventDate (startdate). What could cause this, when both dates are set in the same Sharepoint calendar event at the same time, by the same user? And this occurs ONLY for events which are not all-day events.
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.
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
