Forum Discussion
Solved
PowerBI - Exchange - Inbox Categories
Howdy, My company utilises Outlook Categories to manage tasks. Some emails end up with multiple categories, i.e. Category 1: what type of work it is?, 2. Staff Category: Who is working on it. W...
It looks like it repeats the email for each Category? Is there an ID field you can use to identify each email?
I've done a video on Survey data that has a similar (though not identical) dilemna in terms of needing to create Dimension tables and reconcile responses to questions where the respondent can select multiple items (similar to tagging the same email with multiple categories).
It might help: https://www.youtube.com/watch?v=UAjAtbN1MAY
AllisonKennedy, Thanks for the reply. i am connecting directly to exchange mailbox. Only 1 table, "Mail".
In Outlook it looks like this...
In Power Query it looks like...
Thanks
Matt