英文:
Is it possible to view an entire M365 tenant's Exchange data in PowerBI?
问题
抱歉，我不是PowerBI用户。我想知道在我将客户转介到其他地方之前，PowerBI是否可以实现客户的请求：
客户希望看到每周报告，突出显示来自外部联系人的电子邮件总数和来自内部联系人的电子邮件总数，以及发送的电子邮件情况。他们还想知道有多少外部电子邮件得到了回应，以及回应之间的时间 - 如果可能的话，平均值最好。
如果您认为PowerBI可以从Exchange中获取这些数据，请告诉我，以便我可以外包给第三方。如果不行，也许其他工具可以胜任？
谢谢！
我已经尝试在PowerBI中连接到Exchange在线模块，但只能选择一个电子邮件连接。我需要查看整个租户的电子邮件。
英文:
Apologies in advanced, I'm not a PowerBI user. I would like to know if this customer's query is possible with PowerBI before I send them elsewhere:
The customer would like to see a weekly report highlighting the total number of emails received from external contacts and the total number of emails received from internal contacts. The same but for sent emails. They would also like a breakdown of how many external emails are responded to, and the time taken between responses - averages would be best if possible.
If you think this is something PowerBI can pull from Exchange please let me know so I can outsource to a third party. If not perhaps another tool would do the trick?
Thanks!
I have tried connecting to the Exchange online module in PowerBI, but only got the option to connect to one email at a time. I would need to see the entire tenant's emails.
答案1
得分: 2
Power BI仅是这个过程中的报告端点。它可以处理数据的报告，但无法检索数据。真正的工作将是编写PowerShell脚本，使用MS Graph提取相关数据，然后将其存储在Azure的数据库中，以便PowerBI连接。
英文:
Power BI is just the reporting end point in a process like this. It can certainly handle the reporting of the data but it can't retrieve the data. The real work would be writing a powershell script to extract relevant data using MS Graph and then storing that in a DB in Azure for PowerBI to then connect to.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论