20  Consuming Content & Q&A feature for data exploration

NoteThe Consumer’s Perspective

Every report and dashboard covered in this book has been discussed from the perspective of the report builder: connecting to data, modeling, building visuals, formatting, and publishing. This final chapter shifts to the other side of that equation: the consumer. Consumers are the people who receive, open, and use Power BI content that others have built and shared with them. They may be executives checking morning KPIs, analysts exploring regional trends, operations managers tracking daily performance, or field teams monitoring their own targets.

Understanding how to consume Power BI content effectively, how to navigate the Service as a viewer, how to ask questions of data using natural language, and how to stay informed through alerts and subscriptions makes the difference between a report that sits unopened and one that genuinely changes how decisions are made.

flowchart LR
    A[Published Content <br> Reports & Dashboards] --> B[Consumer in <br> Power BI Service]
    B --> C[View & Explore <br> Slicers, Filters <br> Drill-down]
    B --> D[Q&A <br> Natural language <br> queries]
    B --> E[Alerts <br> Threshold <br> notifications]
    B --> F[Subscriptions <br> Scheduled email <br> snapshots]
    B --> G[Export <br> PDF, Excel, CSV]
    classDef default fill:#004466,color:#ffffff,stroke:#ffcc00,stroke-width:3px,rx:10px,ry:10px;

20.1 Getting Started as a Consumer

20.1.1 Navigating the Power BI Service as a Consumer

NoteWhere Consumers Find Their Content

When a consumer signs in to the Power BI Service at app.powerbi.com, they land on the Home page. Home is personalized to each user and shows recently visited content, content shared directly with them, and recommended items from the organization. For most consumers, the Home page is the primary starting point for every session.

Content shared with a consumer appears in several places depending on how it was shared:

  • Home — recent and recommended content surfaced automatically
  • Shared with me — a dedicated section (accessible from the Browse menu) listing every report and dashboard that has been shared with them directly via the Share feature
  • Apps — if the content was distributed as a Power BI app, it appears here. The Apps section shows all apps the consumer has installed or that have been pushed to them by an administrator
  • Workspaces — if the consumer is a Viewer member of a shared workspace, the workspace content is visible under the Workspaces section in the left navigation

[Insert screenshot of the Power BI Service Home page from a consumer’s perspective, showing the Recent section with report and dashboard thumbnails, the Recommended section below it, and the left navigation panel with Home, Browse, Apps, and Workspaces sections highlighted]

NoteFinding Content with Search

For consumers who know the name of a report or dashboard they are looking for but cannot immediately find it in the Home view, the Search bar at the top of the Power BI Service provides a fast way to locate any content they have access to.

Clicking the search icon (magnifying glass) in the top navigation bar opens a global search field. Typing a report name, a dataset name, a workspace name, or even a keyword that appears in a report’s description or field names returns matching results filtered to content the signed-in user has permission to access. Results are grouped by content type (Reports, Dashboards, Apps, Workspaces, Datasets) for easy identification.

[Insert screenshot of the Power BI Service global search open with a search term typed, showing search results grouped by type (Reports, Dashboards, Apps) with matching items listed under each category]

20.1.2 Consuming Reports and Dashboards as a Viewer

NoteWhat a Viewer Can Do in a Report

When a consumer opens a shared report or a report inside an app, it opens in Reading view. In Reading view, the consumer cannot change the report’s layout, add or remove visuals, or edit any DAX formulas. However, they have full access to the report’s interactive features, which is where most of the value for a consumer lies.

In Reading view, a consumer can:

  • Use slicers to filter the data to a specific region, time period, product category, or any other dimension the report builder has made available
  • Click visual elements (bars, lines, pie slices, map regions) to trigger cross-filtering and cross-highlighting across other visuals on the page
  • Apply filters from the Filters pane (if the report builder has left it visible and unlocked)
  • Drill down through hierarchy levels in visuals that have a hierarchy configured
  • Navigate between report pages using the page tabs at the bottom of the report
  • Hover over data points to see tooltip information
  • Use drill-through by right-clicking a data point to navigate to a detail page (if the report builder has configured drill-through)

[Insert screenshot of a report in Reading view in the Power BI Service, showing the slicer panel on the left, a bar chart with one bar clicked and cross-highlighting active on the other visuals, the page navigation tabs at the bottom, and the Filters pane visible on the right]

NoteWhat a Viewer Can Do on a Dashboard

A dashboard in the Power BI Service is a single-page collection of tiles pinned from reports. As a consumer interacting with a dashboard:

  • Click any tile to navigate directly to the underlying report page it was pinned from, where the full interactive report experience is available
  • Hover over tiles to see the tile’s subtitle, last refresh time, and any configured tooltip text
  • Use the Q&A input box at the top of the dashboard (if enabled) to ask natural language questions about the data
  • Set data alerts on numeric or KPI tiles to receive notifications when values cross a threshold (covered later in this chapter)
  • View in focus mode by clicking the focus icon on a tile to expand a single tile to fill the browser window for a closer look

[Insert screenshot of a dashboard in the Power BI Service showing several tiles of different sizes, the Q&A input bar at the top of the canvas, and one tile showing the hover tooltip with the last refresh timestamp visible]

NoteFocus Mode and Full Screen

Two viewing modes help consumers see a specific visual or the entire report more clearly:

Focus mode expands a single visual or dashboard tile to fill the browser window, hiding all other visuals and the surrounding interface. It is useful when a consumer wants to examine one chart in detail without distraction. To enter Focus mode, hover over any visual or tile and click the Focus mode icon (diagonal arrows expanding outward) that appears in the visual’s toolbar. Click Back to report or press Escape to exit.

Full screen mode hides the Power BI Service navigation bar and expands the entire report or dashboard to fill the screen, maximizing the display area. It is most useful during presentations or when viewing a report on a large screen. Press F11 or use the full-screen icon in the toolbar to enter full-screen mode. Press Escape to exit.

[Insert screenshot showing the same bar chart in its normal report view on the left and in Focus mode on the right, where it fills the entire browser window with no surrounding visuals visible, illustrating the expanded view]

TipUse the Report Page Navigator for Multi-Page Reports

On reports with many pages, the page tabs at the bottom of the canvas can become crowded and difficult to navigate by clicking tabs individually. If the report builder has added a page navigation button panel (a set of buttons in the report body that link to different pages), use those buttons for more intuitive navigation. Alternatively, if the report is viewed in the Power BI mobile app, swiping left and right between pages is the primary navigation gesture.

20.2 Using the Q&A Feature

20.2.1 Using the Q&A Feature

NoteAsking Questions in Plain Language

The Q&A feature in the Power BI Service allows consumers to type questions about the data in natural, everyday language and receive an automatically generated visual answer. It is one of the most accessible ways for non-technical users to explore data independently, without needing to understand how the report was built or which visuals are available.

Q&A is available in two places: at the top of every dashboard (as an input bar that opens a full Q&A page when clicked) and as a dedicated Q&A visual that report builders can place on a report page. In both cases, the experience is the same: type a question, see a visual answer, and optionally convert that answer into a permanent visual.

[Insert screenshot of the Q&A full page experience in the Power BI Service, showing the large search bar at the top with a question typed (“show total sales by region for 2025”), the automatically generated bar chart displayed below the input, and a row of suggested question chips beneath the search bar]

NoteHow to Use Q&A

To use Q&A from a dashboard:

  1. Click the Ask a question about your data input bar at the top of the dashboard. The Q&A full-page experience opens
  2. Type a question in natural language. Q&A begins suggesting completions as you type, based on the fields and measures available in the underlying datasets
  3. Press Enter or click a suggestion to generate the visual answer
  4. The result appears below the search bar as a chart, table, card, or other visual type that Q&A determines is most appropriate for the question

If the initial visual type is not what you wanted, you can:

  • Rephrase the question to guide Q&A toward a different visual type (for example, adding “as a line chart” or “as a table” to the end of the question)
  • Click the visual type icons that appear above the answer to switch between chart types manually

[Insert screenshot of the Q&A interface showing the typed question “what is the average order value by product category”, the auto-generated bar chart result below it, and the visual type selector icons appearing above the result allowing the user to switch to a table or line chart]

NoteQ&A Question Examples

Q&A understands a wide range of question formats and field name references. The examples below illustrate the variety of questions a consumer can ask:

  • “Total revenue this year”
  • “Show me sales by region as a map”
  • “Top 5 products by revenue”
  • “Average order value by month”
  • “How many customers placed an order last quarter?”
  • “Revenue vs target for each region”
  • “Which salesperson had the highest sales in 2024?”
  • “Show orders where delivery was late as a table”

The quality of Q&A results depends on how well the dataset’s field names, measure names, and synonyms match the language the consumer naturally uses. If a consumer asks “how much did we sell?” but the measure is named “Total Revenue” with no synonyms, Q&A may not find the right measure. Report builders can improve Q&A accuracy by configuring synonyms through the Q&A setup panel.

[Insert screenshot of the Q&A interface showing a question about late deliveries typed in, with the result displaying a table of late order records filtered automatically based on the natural language condition in the question]

NoteConverting a Q&A Result to a Visual

When Q&A produces a useful result that the consumer wants to keep as a permanent visual on a report page, they can convert it directly:

  1. After generating a Q&A result, click the Pin visual icon (the pushpin icon) that appears in the top-right corner of the generated visual
  2. Choose an existing dashboard or create a new one to pin the visual to
  3. The visual is pinned as a tile on the selected dashboard, refreshing automatically with each data refresh

Alternatively, if the consumer has edit permissions on the report, they can click the Edit button that appears above the Q&A result to convert it into a standard Power BI visual that can be added to a report page and formatted like any other visual.

[Insert screenshot of a Q&A result with the Pin visual icon highlighted in the top-right corner of the generated chart, and the Pin to dashboard dialog open showing the dashboard selection options]

TipQ&A Works Across All Datasets in a Dashboard

A dashboard in the Power BI Service can display tiles pinned from multiple different reports and datasets. The Q&A feature on a dashboard queries across all the datasets that have tiles pinned to that dashboard, not just one. This means a consumer can ask questions that span data from different sources, as long as those sources are represented by tiles on the dashboard. The broader and more diverse the dashboard’s tile collection, the wider the scope of questions Q&A can answer.

20.3 Alerts and Subscriptions

20.3.1 Data Alerts on Dashboard Tiles

NoteWhat Are Data Alerts?

Data alerts are threshold-based notifications that the Power BI Service sends to a consumer when a specific metric on a dashboard tile crosses a defined value. A consumer can set an alert on a KPI tile that says “notify me when Monthly Revenue falls below ₹10,000,000” or “notify me when Website Uptime drops below 99%”. Power BI checks the value each time the dataset refreshes and sends a notification if the threshold is crossed.

Alerts are personal: each consumer sets their own alerts on tiles they care about. The report builder does not configure alerts for consumers. Each alert belongs to the individual who set it, and only that person receives the notification.

[Insert screenshot of a dashboard with a KPI tile showing a revenue metric, with the Manage alerts panel open on the right side showing an alert configured with the condition “Below ₹10,000,000” and the notification channel set to email and Power BI notification center]

NoteHow to Set a Data Alert

Data alerts can be set on dashboard tiles that display a single numeric value: Card tiles, KPI tiles, and Gauge tiles. Alerts are not available on chart tiles (bar charts, line charts, etc.).

To set a data alert:

  1. Open the dashboard in the Power BI Service
  2. Hover over the tile you want to set an alert on
  3. Click the three-dot More options menu that appears in the tile’s header
  4. Select Manage alerts
  5. In the Manage alerts panel, click Add alert rule
  6. Configure the alert:
    • Condition — select “Above” or “Below”
    • Threshold — enter the numeric value that triggers the alert
    • Frequency — choose “At most once per hour” or “At most once per day” to control how often you receive notifications even if the condition remains true
    • Email notification — toggle on to receive an email each time the alert fires
  7. Click Save and close

[Insert screenshot of the Add alert rule panel in the Power BI Service showing the Condition dropdown set to “Below”, the Threshold field with a value entered, the notification frequency options, and the email notification toggle, with the Save and close button at the bottom]

NoteHow Alert Notifications Arrive

When an alert threshold is crossed, Power BI delivers the notification through two channels simultaneously:

Power BI notification center: A bell icon appears in the top navigation bar of the Power BI Service with a red badge indicating new notifications. Clicking the bell opens the notification center, which lists all recent alerts with the tile name, the threshold that was crossed, the current value, and a direct link to open the dashboard.

Email notification: If the email toggle was enabled when setting up the alert, an email is sent to the signed-in user’s address. The email contains the alert name, the condition that was met, the current metric value, a timestamp, and a direct link to the dashboard.

[Insert screenshot of the Power BI Service notification center open, showing one or two alert notifications listed with the metric name, the triggered condition (e.g., “Monthly Revenue is below ₹10,000,000”), the current value, and a link to view the dashboard]

TipUse Alerts for Operational Monitoring, Not Daily Reporting

Data alerts are most valuable for genuinely exception-based monitoring: situations where you only need to act when something goes wrong or crosses a critical boundary. They are not a substitute for regularly checking a dashboard. Set alerts on the metrics where a boundary crossing requires an immediate response (a KPI falling below target, a system metric exceeding a safe threshold, an inventory level dropping too low) and let the scheduled refresh and dashboard viewing handle routine monitoring of all other metrics.

20.3.2 Subscribing to Reports and Dashboards

NoteWhat Is a Subscription?

A subscription in the Power BI Service delivers a scheduled email snapshot of a report page or dashboard to one or more recipients at a defined frequency. Unlike data alerts (which fire only when a condition is met), subscriptions send on a fixed schedule regardless of what the data shows. Each subscription email contains a static image of the report page or dashboard at the moment it was generated, along with a direct link to open the live interactive version.

Subscriptions are the right tool for stakeholders who want the data to come to them on a regular schedule (daily briefings, weekly summaries, monthly reports) rather than having to remember to log in and check the Service. They are also useful for sharing a periodic snapshot with recipients who prefer email over navigating the Power BI Service.

NoteHow to Create a Subscription

To subscribe to a report page or dashboard:

  1. Open the report or dashboard in the Power BI Service
  2. Click the Subscribe icon in the top toolbar. It appears as an envelope icon and may be labelled “Subscribe to emails” depending on your version
  3. The Subscriptions panel opens on the right. If no subscriptions exist yet, click Add new subscription
  4. Configure the subscription settings:
    • Subscription name — a label to identify this subscription in the subscription management list
    • Frequency — choose from Daily, Weekly, or After data refresh
      • Daily — sends at a specific time of day every day
      • Weekly — sends on selected days of the week at a specific time
      • After data refresh — sends automatically after each successful scheduled dataset refresh, ensuring recipients always receive the most up-to-date snapshot
    • Start date and End date — define the active period for the subscription. Setting an end date is useful for project-based subscriptions that should stop automatically
    • Time zone — select the time zone for the schedule
    • Subject — the email subject line
    • Message — an optional personal message included in the email body, such as a note explaining what the recipient should look for in the attached snapshot
    • Include my link — toggle on to include a direct link back to the live interactive report or dashboard
    • Recipients — by default the subscription sends to your own email address. With a Pro or Premium licence, you can add additional recipients by entering their email addresses
  5. Click Save and close

[Insert screenshot of the Add new subscription panel in the Power BI Service showing all the configuration fields: Subscription name, Frequency dropdown, time zone selector, Start and End date pickers, Subject, Message body, Include my link toggle, and Recipients field, with the Save and close button visible at the bottom]

NoteManaging Existing Subscriptions

To view, edit, or delete your existing subscriptions:

  1. Click the Subscribe icon in the toolbar of the report or dashboard
  2. The Subscriptions panel lists all subscriptions configured for that item
  3. Click any subscription name to expand it and see its current settings
  4. Click the pencil icon to edit the settings, or the trash icon to delete the subscription

To manage all subscriptions across all reports and dashboards at once, go to Settings → Manage subscriptions in the Power BI Service. This shows a consolidated list of every active subscription associated with your account, with the report or dashboard name, the frequency, and the next scheduled send time.

[Insert screenshot of the Manage subscriptions page in the Power BI Service settings showing a table of active subscriptions with columns for the subscription name, report/dashboard name, frequency, next send time, and action buttons for Edit and Delete]

TipSubscribe Key Stakeholders on Their Behalf

Report builders and workspace members with appropriate permissions can create subscriptions on behalf of others. If you know that a specific executive checks a dashboard every Monday morning, set up a subscription for them with a Monday morning delivery and a brief explanatory message in the subscription email body. This proactively delivers the data to them without requiring them to configure it themselves, increasing the likelihood that the report is actually read and acted upon regularly.

20.4 Exporting Content

20.4.1 Exporting and Downloading as a Consumer

NoteWhat Consumers Can Export

Consumers with read access to a report can export content for offline use, distribution to recipients without Power BI accounts, or further analysis in other tools. The export options available to a consumer depend on what the report builder has enabled in the report settings and what the consumer’s licence allows.

The primary export options available from the Power BI Service for consumers are:

  • Export to PDF — saves the current report page (or all pages) as a static PDF document
  • Export data from a visual — downloads the data displayed in a specific visual as an Excel or CSV file
  • Print — opens the browser print dialog to print the current report page

[Insert screenshot of the Export menu in the Power BI Service report toolbar showing the available export options: PDF, PowerPoint, and the More options with the print option, alongside the visual-level More options menu showing Export data]

Exporting a Report to PDF

NoteHow to Export to PDF as a Consumer
  1. Open the report in the Power BI Service in Reading view
  2. Click Export in the top toolbar and select PDF
  3. Choose whether to export the current page only or all pages in the report
  4. Click Export. The Power BI Service generates the PDF (this may take a few moments for multi-page reports) and downloads it to your browser’s default download folder
  5. Open the downloaded PDF to verify it captured the correct data and filter state

The PDF reflects all current slicer selections and filter states at the moment of export. If you want a specific filtered view (for example, just the North region’s data), apply the relevant slicer selections before exporting.

[Insert screenshot of the PDF export options panel showing the page selection radio buttons (Current page, All pages) and the Export button, alongside the resulting downloaded PDF open in a PDF viewer showing the report page rendered as a static document]

Exporting Data from a Visual

NoteHow to Export Visual Data to Excel or CSV

To download the data behind a specific visual for further analysis in Excel or another tool:

  1. Hover over the visual in the report (or on a dashboard tile) and click the More options menu (three dots) in the visual’s header
  2. Select Export data
  3. In the export dialog, choose the data format:
    • Summarized data — exports the aggregated values shown in the visual (the same data points visible in the chart, in tabular form)
    • Underlying data — exports the row-level data feeding the visual before aggregation. This option may be disabled if the report builder has restricted it for data governance reasons
  4. Choose the file format: Excel (.xlsx) or CSV (.csv)
  5. Click Export. The file is downloaded to your browser’s download folder

[Insert screenshot of the Export data dialog showing the Summarized data and Underlying data radio button options, the file format selector showing Excel and CSV, and the Export button]

WarningExported Data Reflects the Current Filter State

The data exported from a visual is always filtered to exactly what the visual is currently showing. Page-level filters, report-level filters, and active slicer selections all apply to the exported data. If the consumer intends to export the complete unfiltered dataset, they must first clear all slicers and filters before exporting. Exporting without checking the filter state is one of the most common causes of incomplete or misleading exports that lead to incorrect analysis downstream.

20.5 Making the Most of Consumed Content

20.5.1 Making the Most of Consumed Content

NoteThe Consumer’s Toolkit

A Power BI consumer has access to a rich set of tools for getting value from shared content. Reading view provides full interactivity for exploring data through slicers, cross-filtering, and drill-down. Q&A enables natural language data exploration without any technical knowledge. Data alerts ensure that critical threshold crossings are never missed. Subscriptions deliver regular snapshots to the inbox automatically. Exports make data available for offline use and further analysis.

Using these tools well is not about technical expertise. It is about knowing what question you are trying to answer, using the available interactive controls to navigate toward that answer, and knowing when to export or subscribe versus when to explore live. The report builder has laid the foundation: the consumer’s role is to make full use of it.

ImportantFeedback Makes Reports Better

The most effective Power BI deployments are iterative. Consumers who actively communicate what they find useful, what they find confusing, what filters they wish existed, and what questions the current report cannot answer are the most valuable contributors to an improving report ecosystem. If you are a consumer and the report does not answer your question, tell the report builder. If Q&A cannot interpret your question correctly, flag it. If an alert threshold seems wrong in practice, adjust it. Power BI reports improve fastest when the feedback loop between consumers and builders is short, direct, and ongoing.

Summary

Concept Description
Consumer Experience
Apps and Workspaces Where end users discover and open the reports you publish
Mobile Layout Phone-friendly layouts published with the report
Subscriptions Email digests delivered on a schedule
Personal Bookmarks Per-user saved view states that don't disturb other readers
Q&A Natural Language Type or speak a question and get a generated visual answer
AI and Conversation
Synonyms and Featured Curating Q&A vocabulary for accurate matches
Comments Threaded discussions tied to visuals and report pages
Insights and Anomalies AI-generated insights that highlight trends and anomalies