Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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])),