Launch Deal · 50% off 1st month ·

3.7 — Export Settings, Mobile Layout, Personalization, Accessibility and Automatic Page Refresh

PL-300 Domain 3 · Skill 3.7

What You Need to Know

Export settings

File > Options and settings > Options > Current file > Report settings > Export data sets what readers can export from visuals in the service:

Setting Readers can export
Summarized data, data with current layout and underlying data Everything, including the rows behind the visual
Summarized data and data with current layout Only what the visual shows
No data Nothing
  • Fabric admins can restrict exporting further with tenant settings (export to Excel, CSV, PowerPoint, PDF, Analyze in Excel). The stricter of the report and tenant settings wins.
  • Exporting underlying data needs Build permission on the semantic model.
  • Readers can also export the whole report to PDF or PowerPoint, or use Analyze in Excel, unless those are turned off.
  • Sensitivity labels travel with exported files (lesson 4.6).

Design for mobile devices

View > Mobile layout opens a phone-sized canvas. You drag the page's visuals onto it, resize them, and can give visuals mobile-specific formatting. Phones in portrait show the mobile layout; without one, readers see the full page scaled down. Slicers, bookmarks and buttons work on mobile.

Personalization

  • Personalize visuals (in Report settings, on by default for new reports) lets readers in the service change a visual's type, fields and aggregation for themselves, without editing the report. You can turn the icon off per visual (Format > General > Header icons).
  • Readers can save their changes as a personal bookmark and reset to default at any time.
  • Personalization doesn't change the report for anyone else.

Accessibility

Practice How
Alt text Format > General > Alt text on every visual (can be dynamic, from a measure). Screen readers read it
Tab order Selection pane > Tab order: logical order, and hide decorative shapes from tab order
Titles and labels Clear titles, axis titles and data labels
Don't rely on color alone Add markers, different line styles, icons or labels
Contrast At least 4.5:1 between text and background; use an accessible theme
Show as table Readers press Alt+Shift+F11 (or use Show as table) to read the data behind a visual
Keyboard navigation Ctrl+F6 moves between page sections; Tab moves between visuals

Automatic page refresh

For pages over DirectQuery sources, Format page > Page refresh refreshes the visuals automatically.

Type Behavior Notes
Fixed interval Refreshes every N seconds, minutes, hours On shared capacity (Pro), the minimum is 30 minutes. On Premium/Fabric capacities, the capacity admin sets the minimum
Change detection Runs a measure at an interval, and refreshes visuals only when the measure's value changes (for example MAX(Orders[LastUpdated])) Needs a Premium or Fabric capacity. One change-detection measure per model

Import tables don't change between scheduled refreshes, so automatic page refresh doesn't help them. Each refresh sends queries to the source, so short intervals add load.

Key Concept: Report settings control export and personalization; accessibility comes from alt text, tab order, contrast and not relying on color; automatic page refresh is for DirectQuery pages, with change detection on capacity.

Exam Traps

  • Expecting readers without Build permission to export underlying data
  • Setting a 1-minute fixed refresh interval for a report in a Pro workspace (minimum 30 minutes)
  • Using automatic page refresh on an Import-only model
  • Relying on red/green alone to show good and bad
  • Duplicating a report for phone users instead of creating a mobile layout

Check your understanding

Practice Scenario

🔒 This practice scenario is part of Skillmarked Pro

The lessons stay free. Pro unlocks the other 22 PL-300 practice scenarios and the 50-question timed mock exam, plus everything for every other exam.

See plans

Launch Deal: first month €9.95, then €19.90/month. Enter code LAUNCH50 at checkout. Ends 1 December.

Cancel anytime. Or €199 a year, which saves 17%.

Not sure yet? Try 10 free mock exam questions.

Already Pro? Log in.