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.
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.
Sources
- Export data from visualizations, Microsoft Learn
- Optimize reports for Power BI mobile apps, Microsoft Learn
- Let users personalize visuals in a report, Microsoft Learn
- Design Power BI reports for accessibility, Microsoft Learn
- Automatic page refresh in Power BI, Microsoft Learn