问题

I'm not a PowerBI user. 我不是PowerBI用户。 I would like to know if this customer's query is possible with PowerBI before I send them elsewhere: 我想知道是否可以使用PowerBI来满足客户的查询需求，然后再决定是否转向其他解决方案。 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? 如果您认为PowerBI可以从Exchange获取这些数据，请告诉我，以便我可以外包给第三方。如果不能，也许其他工具可以解决问题？ 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. 我尝试连接到PowerBI中的Exchange在线模块，但只能连接一个电子邮件，我需要查看整个租户的电子邮件。

答案1

得分: 2

Power BI仅是此过程中的报告端点。它可以处理数据报告，但无法检索数据。真正的工作将是编写PowerShell脚本，使用MS Graph提取相关数据，然后将其存储在Azure数据库中，以供PowerBI连接。