使用 Power BI 连接到 TwilioConnect to Twilio with Power BI

适用于 Power BI 的 Microsoft Twilio 内容包允许将数据导入 Power BI 并创建全新的 Twilio 仪表板 和报表,呈现你对数据的见解。The Microsoft Twilio content pack for Power BI allows you to pull your data into Power BI and creates an out of box Twilio dashboard and report that shows insights on your data. 你还可以对 Power BI 创建的数据集创建报表和仪表板。You can also create your custom reports and dashboard on the dataset Power BI creates. 数据将每天刷新一次,因此你看到的始终都是最新数据。The data will be refreshed once a day so you are always looking at the latest data.

连接到适用于 Power BI 的 Twilio 内容包Connect to the Twilio content pack for Power BI.

如何连接How to connect

  1. 选择左侧导航窗格底部的获取数据Select Get Data at the bottom of the left navigation pane.

  2. 服务框中,选择获取In the Services box, select Get.

  3. 选择 Twilio > 获取Select Twilio > Get.

  4. 对于身份验证方法,请选择oAuth2 >“登录”。For Authentication Method, select oAuth2 > Sign In. 出现提示时,请提供你的 Twilio 凭据并授权 Power BI 应用程序访问你的数据。When prompted provide your Twilio credentials and authorize the Power BI application to access your data.

  5. 此操作将开始从你的 Twilio 帐户导入数据,且你的仪表板将使用过去 30 天的调用和消息使用情况进行填充。This will begin importing data from your Twilio account, and you will have your dashboard populated with your calls and messages usage for the past 30 days.

下一步?What now?

包含的内容What's included

有关最近 30 天内的所有调用和消息事务的详细信息。The details for all calls and messages transactions for the last 30 days. 你可以执行有关此数据的各种类型的分析和聚合运算。You can do all sorts of analysis and aggregation on this data.

你可能想要密切关注的一组已经聚合的统计信息。A set of already aggregated stats that you may want to keep an eye on. 此数据集包括:This set includes:

    All Time Calls Count  
    All Time Calls Duration  
    All Time Calls Price  
    All Time Messages Price  
    All Time Messages Count  
    All Time Count of Phone Numbers  
    All Time Price of Phone Numbers  
    All Time Twilio Client Calls Price  
    All Time Twilio Client Calls Duration  
    All Time Twilio Client Calls Count  
    All Time Total Price  
    All Time Inbound Calls Price  
    All Time Inbound Calls Duration  
    All Time Inbound Calls Count  
    All Time Outbound Calls Price  
    All Time Outbound Calls Duration  
    All Time Outbound Calls Count  
    This Month Calls Price  
    This Month Calls Duration  
    This Month Calls Count  
    This Month Messages Count  
    This Month Messages Price  
    This Month Count of Phone Numbers  
    This Month Price of Phone Numbers  
    This Month Twilio Client Calls Price  
    This Month Twilio Client Calls Duration  
    This Month Twilio Client Calls Count  
    This Month Total Price  
    This Month Inbound Calls Price  
    This Month Inbound Calls Duration  
    This Month Inbound Calls Count  
    This Month Outbound Calls Price  
    This Month Outbound Calls Duration  
    This Month Outbound Calls Count  
    This Month Inbound Messages Price  
    This Month Inbound Messages Count  
    This Month Outbound Messages Price  
    This Month Outbound Messages Count

故障排除Troubleshooting

如果你在过去 30 天内的数据量十分巨大(成百上千个事务),则数据检索步骤可能会失败。If you have a very large amount of data in the past 30 days (hundreds of thousands of transactions), the data retrieval step might fail. 我们已经注意到该问题并正在努力解决它。We are aware of the problem and working on solving it. 同时,如果遇到此问题,请使用 Power BI 页面顶部的支持链接告诉我们,我们将与你联系进行进一步调查。Meanwhile, if you hit this issue please use the support link at the top of your Power BI page to let us know and we'll contact you for further investigations.

后续步骤Next steps

Power BI 入门Get started in Power BI

在 Power BI 中获取数据Get data in Power BI