Connection to Exchange calendars appointment series, only the first appointment is displayed

[TobJa]

Hi Everyone,

I have a problem with the Exchange Connector. I want to read all entries of an Outlook calendar into Power Query. This works so far, but only the first appointment of a series is displayed. All further appointments of the series are not taken over in Power Query.
If I export the calendar as csv and then read it into Power Query, they are all taken over.
What do I have to do to get all appointments of an appointment series displayed in Power Query via the Exchange connector?

Kindly assist.

Thanks and Regards,

Tobias

[foodd]

Transforming Exchange server data with recurring appointments in Power BI/ Power Query

Use the solution powerquery-m pattern in this post, and adjust the interval on step on line #13 from 7 to 1 (highlighted in RED) if you want to show those reoccurrences that are daily, weekly, etc.   Do follow the guidance provided in the referenced post.  To verify what date is returned, scroll to the right, and the column is named  "DatesInPeriod"

The step is :

#"Added Custom3" = Table.AddColumn(#"Expanded DatesInPeriod", "DateDiffModInterval", each Number.Mod(Duration.Days(Duration.From([DatesInPeriod]-[RecurrenceStartDate])),1*[Attributes.Recurrence.Interval])),