Call Journey has released a new version of the Power BI dashboard template (Data Bridge - 1.3.062621.pbit) that has improved performance for an initial load and data refresh.
To understand how this dashboard has changed, please see the following table:
Table/ Visual | Comment |
|---|---|
public generated_analytics_data | Removed unused JSON columns to reduce the table size
|
public generated_analytics_client_data | Disabled load |
public generated_analytics_scorecard_data | Disabled load |
Moving Averages ** (can be done with All Agents) |
(please see the additional information for enabling this table) |
Client Phrases Agent Phrases | Disabled load (should/ will remove in reduce workload on public generated_analytics_data) |
Best and Worse Customer Calls
Best and Worse Agent Calls
| Removed visuals and calculations |
How to enable load for a table in Power Query Editor
If you want to utilise the disabled table above, you can simply enable it as follows:
Go to Power Query Editor
...
2. Right-click on a disabled table (you can see the table name in italic format) > then click Enable load
...
3. Click Close & Apply
...
How to add column/s to generated_analytics_data
Note: adding some columns might impact loading performance
Please follow these steps If you require additional columns in generated_analytics_data
Go to Power Query Editor
...
2. Go to public generated_analytics_data > click on Source setting
...
3. Go to SQL statement section > add column/s name (start with “,”, for example “, scorecard”) at the end of the SELECT statement > then click OK
(You can find the columns lists from this link: Data Bridge: BI Connector Service )
...
4. Click Close & Apply
...
Additional Information
Please follow these steps If you prefer the calculation of the Moving Averages table in Power Query
Right-click Moving Averages in Fields > click Delete from model
...
2. Go to Power Query Editor
...
3. Right-click on Moving Averages (disable) > rename to Moving Averages
...
4. Right-click on Moving Averages > then click Enable load
...
5. Click Close & Apply
...