Power BI Schema Updates
How does this affect you?
Out of the box reports are updated automatically. Custom reports and/or in out of the box report copies should be updated manually.
If you use one or more of the removed columns/measures in your custom reports and/or in out of the box report copies, follow the instructions below to update your reports.
If you use one or more of the updated columns/measures in your custom reports and/or in out of the box report copies, no action is needed.
How to prepare for this change?
Visuals using a removed column/measure will be broken after the update:
To fix a broken visual, edit the report by clicking the Edit button, select the broken visual which currently uses the removed column/measure and replace it with the new/updated column/measure.
In version 1.0.23, several out of the box report pages include updated measures. If you use them in your report copies, follow the instructions below to update your reports:
Engagement | Visit Overview
- After the update to 1.0.23, the following visuals will be broken:
- Select the top broken visual, drag the Bucket Name column from the Visits Group table to the Legend. Drag the Bucket Group column from the Visits Group table to the Filters on this visual section and select Length.
- Select the bottom broken visual, drag the Bucket Name column from the Visits Group table to the Group. Drag the Bucket Group column from the Visits Group table to the Filters on this visual section and select Length.
Usability | Slow Pages
Usability | Visitor Technology
Version 1.0.23 - November 2019
Power BI SSAS Model:
Table | Field Name | Field Type | Status | Notes |
FactEvents | EventLogId | Column | Removed | Internal, not in use |
FactEvents | RelatedId | Column | Removed | Internal, not in use |
FactEvents | RequestId | Column | Removed | Internal, not in use |
FactEvents | Timestamp (Visitor Time) | Column | Removed | Use the ClientDate and ClientTime columns |
FactEvents | URL Last Part | Column | Removed | Internal, not in use |
FactEvents | Visits | Measure | Updated |
|
Visits | Average Number of External Links Clicks Per Visit | Measure | Updated |
|
Visits | Average Number of Searches Per Visit | Measure | Added |
|
| Visits | SessionStartDay_key | Column | Added | For internal use only |
Visits Group | Bucket Group | Column | Added | For internal use only |
| Visits Group | Bucket Name | Column | Added | For internal use only |