Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Zakon8
New Member

Power Bi - Outlook meeting report issue

Hi Guys,

 

I'm trying to create report for all meetings from User's Outlook calendar. It's working correctly for 6 of 10 Users. There are no diferences between these calendars(same permissions, in every calendar there are some reccuring meetings without end dates but it's fine). I'm not sure what could be wrong here. I have an error when im trying to expand attribute FirstOccurrence.

 

I was also trying to change type of this column to "text" as I found this solution on this forum, but unfortunately it's also not working.

PowerBi meetings.jpg

 

Error message:

Spoiler
OLE DB or ODBC error: [DataSource.Error] ErrorRecurrenceHasNoOccurrence: Recurrence has no occurrences in the specified range., There are no occurrences in the current recurrence

 

Code:

Spoiler
let
Source = Exchange.Contents("XXXXXX"),
    Calendar1 = Source{[Name="Calendar"]}[Data],
    #"Expanded Attributes" = Table.ExpandRecordColumn(Calendar1, "Attributes", {"AppointmentType", "DeletedOccurrences", "FirstOccurrence", "LastOccurrence", "ModifiedOccurrences", "Organizer", "Recurrence", "Sensitivity"}, {"Attributes.AppointmentType", "Attributes.DeletedOccurrences", "Attributes.FirstOccurrence", "Attributes.LastOccurrence", "Attributes.ModifiedOccurrences", "Attributes.Organizer", "Attributes.Recurrence", "Attributes.Sensitivity"}),
    ExpandCategories = Table.TransformColumns(#"Expanded Attributes", {"Categories", each Text.Combine(List.Transform(_, Text.From), "/"), type text}),
    #"Expanded Attributes.FirstOccurrence" = Table.ExpandRecordColumn(ExpandCategories, "Attributes.FirstOccurrence", {"Start"}, {"Attributes.FirstOccurrence.Start"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Attributes.FirstOccurrence",{{"Attributes.FirstOccurrence.Start", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "CustomStart", each [Attributes.FirstOccurrence.Start]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Attributes.FirstOccurrence.Start"})
in
    #"Removed Columns"

 

3 REPLIES 3
Zakon8
New Member

refreshing.

v-rongtiep-msft
Community Support
Community Support

Hi @Zakon8 ,

 

I have found a similar post, please refer to.

[E2007SP1][EWSMA][C#] CalendarFolder.FindAppointments - Recurrence has no occurrences in the specifi...

  • What is the similar code that uses EWS that works for this user? How does the XML compare?  The 'effective' date for the error makes no sense since that is one year outside of the calendar view window. You might have a corrupt recurring meeting. Did you recently do a migration to 2007? Are you having an issue opening an item in Outlook?

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 


@v-rongtiep-msft wrote:
  •  Did you recently do a migration to 2007? Are you having an issue opening an item in Outlook?

Nope, we are using Exchange 2016 in Hybrid mode, all mailboxes are located on Exchange Online.

Also there is no issue from User perspective with opening these meetings from Outlook. 

 

Any ideas?

 

BR,

Zakon8

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.