Page History
| Table of Contents | ||
|---|---|---|
|
...
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
...
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 | Average Number of External Links Clicks Per Visit | Measure | Updated |
|
Visits | Average Number of Searches Results External Links Clicks Per Visit | Measure | AddedUpdated |
| |
Visits | Average Number of Searches Per Visit | Measure | Added |
| |
| Visits | Number of Events per Visit | Measure | Removed | Internal, not in use | |
Visits | Number of External Clicks Links per Visit | Measure | Removed | Use the Average Number of External Links Clicks Per Visit measure | |
Visits | Number of Search Result Clicks per Visit | Measure | Removed | Use the Average Number of Searches Results Clicks Per Visit measure | |
Visits | Number of Searches Per Visit | Measure | Updated |
| |
Visits | Number of Visits (with pageviews) | Measure | Removed | Use the Visits measure | |
Visits | SessionId | Column | Removed | Use the Visits measure | |
Visits | Page Depth | Measure | Updated |
| |
Visits | Length of Visit (Minutes)
| Measure | Removed | Use the Session Duration in Minutes measure | |
Visits | Session Duration in Minutes | Measure | Added |
| |
Visits | Visit Length - Actual (Minutes)
| Measure | Removed | Use the Session Duration in Minutes measure | |
| 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 |