MailTracking Icon Index Issue in Data Load

[Maha1]

I got Excel Power Query to read data from Microsoft Exchange (Outlook) to track our mailbox recieved emails. It worked until two weeks before I recieved the below error. I found that the issue is comming from "IconIndex" column, which is a default column came when I expanded the "Attribute" column. I wasn't able to identify emails in outlook that had "MailTracking" icon which caused the issue. I still need "IconIndex" column, and I'm afraid that if I filtered the "MailTracking" rows, I will miss count recieve emails.

 

[lbendlin]

Learn to like the question mark ?  - it will allow you to deal with columns that may not exist.

Chris Webb's BI Blog: Handling Added Or Missing Columns In Power Query (crossjoin.co.uk)