Forum Discussion
Maha1
2 years agoHelper II
MailTracking Icon Index Issue in Data Load
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.
1 Reply
- lbendlinSuper User
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)