Create Power BI CallBack Wallboard
You can use Power BI Streaming Datasets to create your own real time wallboard. For example to monitor the callbacks.
Create Streaming Dataset
The first step is to setup a streaming dataset.
- Go to the Power BI portal: https://app.powerbi.com
- Go to the Workspace where you want to create the dataset.
- Select "Create", "Streaming dataset"
- Select "API"
- Give the Dataset a name, for example CallBack The CallBack feature enables the customer to leave his / her number to be called back by an available agent during business hours. Wallboard
- Add the following values:
- datetime - DateTime
- total - Number
- completed - Number
- todo - Number
- retries - Number
- queuename - Text
- Select "Create"
- Copy the "Push URL" for the next part.
Configure Scheduled Task
The next step is to automatically push data to the streaming dataset.
- Request the PowerShell scripts from the supportdesk
- Copy the files to "c:\program files\anywhere365\scripts\CallBackWallboard"
- Edit "PushCallbackWallboard.ps1":
- $endpoint = Push URL from previous part.
- $siteUrl = SharePoint Config page URL
- $libary = outbounddialercalls
- $spusername = domain\username of account with read permissions
- $sppassword = Password of the account
- Save the file
- Open "Task Scheduler"
- Create New Task
- Name = For example "CallBack - PowerBI"
- Change Security options to "Run whether user is logged on or not"
- Trigger, add "New"
- Set to Daily
- In Advanced settings, check "Repeat task every: 5 minutes for a duration of: Indefinitely
- Actions, add "New"
- Program/script = Powershell.exe
- Add arguments = "-ExecutionPolicy Bypass C:\program files\anywhere365\scripts\CallBackWallboard\PushCallbackWallboard.ps1"
- Press "OK" and enter credentials to run the script.
Create Callback Dashboard
Now that the Streaming Dataset is receiving live data, it is time create the dashboard.
- Go back to the Power BI portal
- Select "Create", "Dashboard"
- Give the Dashboard a name, for example CallBack Wallboard
- Select "Add Tile", below some examples:
- Type = Card
- Field = total
- Type = Card
- Field = completed
- Type = Gauge
- Value = completed
- Maximum value = total
- Type = Line chart
- Axis = datetime
- Values = total, todo, completed
Did you find this page helpful?
Sorry about that
Why wasn't this helpful? (check all that apply)
Thank you for your feedback.
Thanks for taking the time to give us some feedback.