Find it...

    Analysing Call Data with Microsoft PowerBI

    Follow

    Once you have extracted the data from the Pexip Management Node (https://support.pexip.com/hc/en-us/articles/115005481863), you can then import to PowerBI and build up charts etc, just like the example below.

    It is also possible to build a realtime integration Pexip from PowerBI or Power Query in Excel.  To do this, all you need is the URI say for the Conference History and then choose to get data from the web as a source - https://<address-mgt-node>/api/admin/history/v1/conference/?limit=100 (100 is an example, you could increase it).

     

    2017-11-13_16-31-53.png

    2017-11-13_16-53-10.png

    Select Basic Authentication and enter your credentials 2017-11-13_17-00-49.png

    Select Convert into Table

    2017-11-13_17-10-38.png

    Right Click List and then change to Drill Down

    2017-11-13_17-12-29.png

    Then select convert to table

    2017-11-13_17-14-25.png

    Then click ok on the next dialogue box

    2017-11-13_17-18-21.png

    Expand the column and click ok

    2017-11-13_17-20-18.png

    Now close the query editor and apply the changes. We can now build a dashboard.

    2017-11-13_17-22-13.png

     

    Here is an example of a dashboard using both the history and conference data.

     

    PowerBI_Dashboard.png

    Was this article helpful?
    0 out of 0 found this helpful

    Comments