Install Power BI template
Before you can start to install the Power BI template, follow the steps below to create SQL views on the SQL CDR Database. Installing the template itself is done in Microsoft Power BI Desktop.
Create SQL views for Power BI
- Open Microsoft SQL Server Management Studio (SSMS) Learn More - Microsoft
- Connect to Server / Instance where the UCC A Unified Contact Center, or UCC, is a queue of interactions (voice, email, IM, etc.) that are handled by Agents. Each UCC has its own settings, IVR menus and Agents. Agents can belong to one or several UCCs and can have multiple skills (competencies). A UCC can be visualized as a contact center “micro service”. Customers can utilize one UCC (e.g. a global helpdesk), a few UCC’s (e.g. for each department or regional office) or hundreds of UCC’s (e.g. for each bed at a hospital). They are interconnected and can all be managed from one central location. Database is located.
- Navigate to the UCC Database
- Right Click Database
- Select New Query
- Paste the SQL code from the Power BI Template package, the SQL queries (.sql file) can be found in the folder where the template itself is (.pbit file).
- Execute the Query (F5)
Power BI Desktop
- Download and Install the latest Microsoft Power BI Desktop. Learn More - Microsoft
- Open the Anywhere365 Power BI Template [ .pbit file from template package]
- Enter Server \ Instance URL
- Enter Database name
- Select the filter method
- By default all data will be loaded into the template
- Fill the previous days parameters
- This parameter cannot be zero, even if the filter parameter is left to default.
- Choose if you want caller and/or agent or neither to be reported anonymously.
- Choose if you want to load the presence and/or call detail data. This can limit the data load but will disable the possibility to report on that data (see note below).
- Load the template
- Log on to the selected database
Deploy

Prerequisites
-
Power BI Template from 8.2 is dependent on the most recent Power BI Desktop version.
-
SQL or Organizational account with access to connect to the Anywhere365 SQL Server.
Installation
The template can be requested via the support portal or partners can download it from the partner portal
-
Open the Power BI template file
-
Enter Server \ Instance URL
-
Enter Database name
Tip: You can use the setting "CDRConnectionString" to get the information.Example: Data Source=sqlserver.domain.net\UCC;Initial Catalog=UCC;Integrated Security=True
-
Choose a Subscription range. If you don't want a dynamic range of data for a subscription, leave the parameter as default (All Time).
-
Choose if you want caller and agent data to be anonymous
Tip: These parameters can be changed at any time after the set up -
If this is your first time connection to this server enter credentials
-
Use tab Windows for Windows account
-
Use tab Database for a SQL account
-
After connecting to the datasource and loading your Anywhere365 Dialogue data into the Power BI template, the template will change to a regular Power BI file (.pbix). Saving the file will ensure that the retrieved data will be saved with the report. In case of sharing, the data will be shared with it

- Open Power BI
- Select "Get Data"
- Select "SQL Server"
- Enter Server \ Instance URL
- (Optional) Enter Database name
Example: Data Source=sqlserver.domain.net\UCC;Initial Catalog=UCC;Integrated Security=True
- If this is your first time connection to this server enter credentials
- Use tab Windows for Windows account
- Use tab Database for a SQL account
- Select the created view
- Select Load
- Select DirectQuery
- Select Ok
Did you find this page helpful?
Yes No
Sorry about that
Why wasn't this helpful? (check all that apply)
Thank you for your feedback.
Great!
Thanks for taking the time to give us some feedback.