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

  1. The following visuals in the Engagement | Visit Overview report copy should be fixed after the update to 1.0.23: 



  2. 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.



  3. 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

  1. The following visual in the Usability | Slow Pages report copy should be fixed after the update to 1.0.23:

     

  2. Select the broken visual and remove the empty column from the Axis list.

Usability | Visitor Technology

  1. The following visuals in the Usability | Visitor Technology report copy should be fixed after the update to 1.0.23:



  2. 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.
  3. Right click the Visits measure from Tooltips and select Show values as > Percent of grand total.



  4. 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

VisitsMeasureUpdated

 

Visits

Average Number of External Links Clicks Per Visit

Measure

Updated

 

Visits

Average Number of Searches Per Visit

Measure

Added

 

VisitsSessionStartDay_keyColumnAddedFor internal use only

Visits Group

Bucket GroupColumnAddedFor internal use only
Visits GroupBucket NameColumnAddedFor internal use only
  • No labels