Forum Discussion

smartis13's avatar
smartis13
New Member
4 years ago

Auto forwarded messages report from Microsoft exchange

Hello community.   Scenario. I setted up few email addresses with the only goal to forward incoming emails to an another address. For example, person A sends an email to the address [email protected]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi smartis13 ,

 

For Exchange Admin Center data (mailbox lists etc) try importaing via the new REST API by just adding the following to Power Query / Power BI as an OData Feed:

https://outlook.office.com/adminApi/beta/[Azure Active Directory Tenant ID]/

(Where [Azure Active Directory Tenant ID] is in XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX format and found via How to find your Azure Active Directory tenant ID)

Or you may refer to this blog to learn how to Publish Real-Time Microsoft Exchange Data to PowerBI.com

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • smartis13's avatar
    smartis13
    New Member
    4 years ago

    Hello Anonymous ,

     

    thank you for the reply. I succesfully imported the data from https://outlook.office.com/adminApi/beta/.

    But sadly I cannot find any information about sent/received/forwarded emails. Seems like there are only counfiguration informations about email accounts.

     

    Kind Regards,

    Martino