To Do Analytics

I receive support requests from my colleagues via email and chat (Teams). IMO, the best way to centralize all the request is Microsoft To Do, because you can flag email messages u wanna register as a ticket and convert chat message as well.

But the thing is that I need some insights too. For this reason I've connected Power BI to the Tasks section of Microsoft Exchange Online.

However, the table that I get is missing of some important fields such as:

• Creation date of the task
• Outlook category use to label the task
• Required by (the person I can select in order to remeber you rise the task)