Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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])),
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
40 | |
30 | |
27 | |
18 | |
17 |