Hi,
I am currently building a team calendar. I have been able to successfully connect my Team Shared Mailbox as a source to Power BI using the data source "Microsoft Exchange."
The problem I am having is that it does not highlight the recurrence events as a singular row.
I have attempted to use: https://community.fabric.microsoft.com/t5/Desktop/Transforming-Exchange-server-data-with-recurring-a... to help me.
However, when comparing the date that has been outputted to what exists on my Shared Mailbox Calendar - some of the recurrence events do not have the right dates. This is most likely due to modifications/ deletions that occur for singular events within the recurrence events.
Is there any work around whereby I can just have live connectivity to the Mailbox data without creating formulas based on the recurrence events? (to ensure that I can capture any modifications/ deletions to the singular events within the recurrence pattern).
Side note:
The current solution I have right now is to export the Shared Mailbox calendar on a weekly basis and converting it to an excel workbook. Subsequently updating the source data to the latest extracted data from my Shared Mailbox calendar.
My goal is minimise the manual work I am required to do on my end.
Hope this makes sense.
