使用 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 BIGet started in Power BI

取得 Power BI 中的資料Get data in Power BI