Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel23

...

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.

...

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. After the The following visuals in the Engagement | Visit Overview report copy should be fixed after the update to 1.0.23, the following visuals will be broken: 

    Image Modified

  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.

    Image Modified

  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.

    Image Modified

Usability | Slow Pages

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

    Image Added 

  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:

    Image Added

  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.

    Image Added

  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