Connexion Exchange Meeting - How to identify cancel Meeting

[Vincent112358]

Hi,

I create a dashboard connect with my exchange calendar. I just load the Meeting, but I can not identify the cancel Meeting. 

Further, when I change the subject of a meeting, I see two meeting in my dashboard (one with the old subject and one with the new...)

Is anybody can help me to identify this meeting ?

Thanks you in advance for your answer,

Best Regards

[v-qiuyu-msft · Accepted solution]

Hi @Vincent112358,

Based on my test in latest Power BI desktop version 2.51.4885.701, after we retrieve data from Calendar table use Exchange Online data source, then go to Query Editor, you will find a column named Attributes, you can expand this column, you will find a column named IsCancelled, which identifies whether the meeting is cancelled or not. 

After we change a existing meeting Subject, refresh the data in Query Editor, it will only have one record with updated subject display here. In your scenario, you can create a test meeting and update it to test again. Also please run the same desktop version as ours. 

Best Regards,
Qiuyun Yu 

[Vincent112358]

Hi @v-qiuyu-msft,

I think it's because I do not load "Calendar" but "Meeting request". In this Table, the field "IsCancelled" is always NULL and we have all the requests.

Thanks