Why Power BI with Capacity?

Many Microsoft 365 partners now have access to Power BI Pro, however the Power BI Premium Capacity, or Fabric Capacity, plans allow for using the Python language to download data automatically via web services like our REST API.

This allows you to keep all records in one central location, instead of each user having to maintain a separate report and dataset on their local machine. This also enables very fast data refresh capabilities, allowing for Power BI to replicate the dashboard behavior of competing dashboard platforms.

What do these do?

All of this data can be found in various forms inside the 1stream console, but the desktop template alongside the included python code will allow a team with more advanced automation capabilities to extend this to any level they need.

We see this as a starting point, and we hope it helps your team build out visualizations and custom integrations to better serve your specific needs.

Get the Code

As this integration process is much more complex, and requires both automation experience and very expensive licensing, we ask that you reach out to our partners@bvoip.com address and ask for these resources.

We will setup a brief 30-minute call to walk through the integration at a high level and provide you the code necessary.

Initial Call Data Collection

1. If you have not done so already, please Generate an API Key which will enable you to access the API to pull data.
2. Follow Microsoft's official documentation to setup a workspace in your capacity if you have not done so already.
3. In the workspace go to New > More options.
   
    
4. Under Data Engineering select Lakehouse.
5. Enter in a name and click Create.
   
6. Select Open notebook.
   
    
7. Select New notebook and then click Open.
   
8. In the top left name this 1stream Call Data.
   
9. Open 1stream Call Data - First Run.py:
   1. Update Line 17 to be your API Key.
   2. Update Line 19 to be the time zone you want data to appear in.
   3. Update Line 22 to be the first date you want to pull data from. Setting this to 01/01/2000 will pull all data, but that can take upwards of an hour depending on call volume.
10. Copy and paste that into the Notebook and click Run all.
    
11. After some time, the 1s_calls table will be generated in the Lakehouse > Tables menu. This can take many minutes depending on how many calls you've made in the past, expect around 3-5 minutes per 10,000 call records.

Scheduled Call Job

1. In the Lakehouse menu, right click 1s_calls and select Copy path.
   
2. Open 1stream Call Data.py and modify Line 18 to use your API Key, Line 20 to be your time zone offset, and Line 22 to be the abfss:// path you just copied above.
3. Paste that into the notebook, and then run it once to ensure it runs properly without error.
4. In the top section go to Run > Schedule to open the Scheduling menu.
   
5. Set Scheduled run to On and set it to run at the cadence you desire. We recommend 2-5 minutes depending on capacity size and call volume and set the end date to far into the future. Then click Apply.
   
6. The job will now run regularly to update the call data.

Scheduled Extension Job

1. Open 1stream Extension Data.py:
   1. Update Line 15 to use your API Key.
   2. Update Line 17 for your time zone offset.
2. Create a new notebook in the workspace by again going to New > More Options and selecting Notebook under Data Engineering.
   
3. On the left click Add under Add Lakehouse.
   
    
4. Select Existing Lakehouse and click Add.
   
5. Select your previously used Lakehouse and click Add.
   
6. In the top left, name your Notebook 1stream Extension Data.
   
    
7. Paste in the python code for 1stream Extension Data.py
8. In the top section go to Run > Schedule to open the Scheduling menu.
   
9. Set Scheduled run to On and set it to run at the cadence you desire. We recommend 2-5 minutes depending on capacity size and call volume and set the end date to far into the future. Then click Apply.
   
10. The job will now run regularly to update the extension data as 1s_extensions.

Using the Data

Unfortunately, a direct query like a Lakehouse does not lend itself well to being templated in Power BI. Included in the zip file is our local Power BI template so you can use that as a baseline, simply follow the Power BI Desktop Integration guide to configure that, and then use that for ideas on how to build your custom reports and dashboards.