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 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
- The following visuals in the Engagement | Visit Overview report copy should be fixed after the update to 1.0.23:
- 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
- The following visual in the Usability | Slow Pages report copy should be fixed after the update to 1.0.23:
- Select the broken visual and remove the empty column from the Axis list.
Usability | Visitor Technology
- The following visuals in the Usability | Visitor Technology report copy should be fixed after the update to 1.0.23:
- Select the Visits by Browser visual, remove the Number of Visits (with pageviews) from Value and the %GT Number of Visits (with pageviews) from Tooltips. Drag the Visits measure from the FactEvents table to the Value and Tooltips.
- Right click the Visits measure from Tooltips and select Show values as > Percent of grand total.
- Repeat steps 2 and 3 for the Visits by Operating System and Visits by Device Type visuals.
...
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 | 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 |