Readying for production

User-Oriented Design in Power BI

Maarten Van den Broeck

Content Developer at DataCamp

Automatic page refresh

• Controls how often a Power BI report will query for new data
• Only works with DirectQuery sources
• Fixed intervals allow for automatic refreshing at scheduled times

Change detection

• Works on tracking the aggregated value of a given field
• Can also use an existing calculated measure
• When there is a tracked change, Power BI automatically refreshes the data source and visuals using that source

Performance considerations

• Refresh interval should be no less than the expected new data arrival interval
• Use Performance Analyzer to review the cost per query
• Each user with a report open runs independent refresh operations

Capacity requirements

• Change detection is only available in a Premium SKU
• Shared workspaces may perform scheduled refreshes at a minimum interval of 30 minutes
• Dedicated capacity allows you to update as frequently as once per second, depending on the storage mode
• A maximum of 10 models with a change detection measure are allowed in a Power BI tenant--in large enterprises with lots of report developers, think about scheduled intervals by default

Configuring report pages

• Specific to a page of a report--multiple pages may have different settings
• Control size, alignment, and layout of report pages
• Control backgrounds and wallpapers
• Control the way the Filter pane looks

Let's practice!

User-Oriented Design in Power BI