Use Explore (preview) in the Power BI service

Explore in the Power BI service is a new experience that allows you to explore your data in a focused way. It's designed to be easy to use, so you can quickly get the answers you need without having to be a Power BI expert. You can use Explore on an existing visual to dig into the underlying data, or you can start with a blank canvas and pull in the data you want to explore.

A few scenarios when you could benefit from Explore include:

• You want to see the underlying data behind a visual in a report or a Copilot-generated visual.
• You want to explore a new semantic model (dataset) to learn about it.
• You want to create a new visual or matrix from scratch, but you don't want to create a report.
• You want to explore a subset of data from a datamart query result.
• You want to explore a semantic model that you don't have permission to edit, but you want to create a new visual or matrix from it.

Follow the steps in this article to learn how to use Explore to build a matrix or visual, customize your Exploration, and then save it to a workspace or as a report to share with others.

Step 1. Navigate to the Explore experience

You can start your experience with Explore from various entry points:

• Visual in a report:

  1. Select ... for more options.
  2. Select Explore this data.

  

• Visual generated by Copilot:

  1. Select the Explore this visual button.

  

• Artifact:

  • From a list:
    1. Select ... for more options.
    2. Then select Explore this data.

  

  • From a report:

    1. Select Explore this data.

    

  • From a datamart:

    1. Select Explore this data.

    

• Workspace:

  1. Select the New button at the top of a workspace.
  2. Then select Exploration.

  

• Data hub:

  1. From the Discover business insights action card on the Details page, select the Explore this data button.

  

Step 2. Build your matrix or visual with Explore (preview)

Regardless of your starting point in Step 1, when you launch the Explore experience, you land in the new focused view. Your data appears in the data pane, and you can edit, drag and drop, or select fields to start building a matrix or visual.

Matrix and visual fields

If you start from a visual, you see that visual on this page. Get a matrix of the underlying data by expanding the Matrix section.

If you didn't start from a visual, you see a blank canvas with matrix and visual fields. You can drag and drop fields from the data pane to the matrix or visual, or select other fields to add.

The matrix and visual are linked. So as you add fields, sort, and drill into to one, the other one is updated automatically, as long as the visual can accurately reflect the sort or drill state.

For example, you might have a visual with a date hierarchy and you want to drill down to quarters. When you drill down on the visual, the matrix updates accordingly.

Visual types

You can also change the type of visual, like stacked bar chart, pie chart, or funnel, by using the options in the visual type gallery. If you don't choose a visual type, Explore autoselects the type that best suits your selected data. To turn off this autoselection, deselect the lightning bolt icon.

Data pane

Use the Choose data section to add or remove data from your Exploration.

Use the Rearrange data section of the data pane to make adjustments. Drag and drop fields from the Choose data section to the Rows, Columns, and Values wells, or use the + Add data button. You only see the field wells for the outlined selection (that is, the matrix or the visual). Select the other side to see its field wells.

Layout options

Switch between a horizontal or vertical orientation by using the Split view horizontally and Split view vertically buttons along the top.

Step 3. Apply filters to your Exploration

As you build out your Exploration, you can also filter your data. Select the Add filter button on the top left to quickly add filters on the fields already in your visual or pick from any fields in your semantic model in the All data section.

In this Exploration experience, the filters are added as pills at the top of view, so you can clearly see what the current filter state is and modify it.

Step 4. Save your Exploration

Save your Exploration to a workspace or as a report.

• Save to a workspace:

  1. Select the Save button in the upper-left corner. A dialog box appears.
  2. Name the Exploration, pick a workspace to save it to, and add a sensitivity label, if applicable. This also saves your current canvas layout (horizontal or vertical) of the Exploration.

  Note

  You can only save Explorations to workspaces in a Premium capacity at this time.

  

• Save as a report:

  1. Select Save.
  2. Select Save as report. This saves your Exploration as a one-page report matching the layout on the screen.

  Note

  You need Build permission on the underlying semantic model to save as a report.

Step 5. Share your Exploration with others

If you want to share your Exploration with others, follow these steps:

1. Select the Share button in the upper-right corner.
2. Select the people who can view your Exploration, such as People in your organization can view, People with existing access, or Specific people.
3. Choose more permissions such as share or edit.
4. Add your recipients' email addresses and an optional message.
5. Select Send. You can send via email or Teams, or select Copy link to share it on your own.

Permissions, requirements, and limitations

To fully benefit from Explore in the Power BI service, be aware of the following permissions, requirements, and limitations.

Permissions and requirements

Explore requires the following permissions and considerations:

• Accessing Explore (preview):

  • By default, people with View permissions on the data can access Explore (preview).

  • Admins can limit the experience to people with Build permissions if they choose by disabling the Users with view permission can launch Explore setting in the admin portal.

  • Exception: For Lake Houses, Build permissions are always required.

    

  • Semantic model owners can also limit exploration of their models to people with Build permissions on an artifact-by-artifact basis. They can do this by disabling the Allow users with view permissions setting in the Explore section of semantic model settings.

    

• Saving an Exploration to a workspace:

  • The destination workspace must be in a Premium capacity.
  • Changing a sensitivity label on a semantic model doesn't currently propagate down to the Exploration that you create for it.
  • If you save to My workspace, you might need to refresh your page to see the newly saved Exploration artifact.

• Saving an Exploration as a report:

  • You need Build permissions on the underlying semantic model.

• Sharing an Exploration:

  • You need a Power BI Pro or Premium Per User (PPU) license.
  • You need to grant View permissions to the underlying semantic model so your recipients can view the Exploration.
    • If you skip this step, your recipients have to request permissions to view the Exploration.
  • Explorations aren't currently shown in lineage view as related to the semantic model.

Limitations

Explore has some limitations. Here are some important things to keep in mind.

• It's not supported in the Power BI mobile app
• There's no entry point from artifacts in the list view of semantic models and reports on the Power BI service Home
• Custom visuals aren't supported
• The following native visuals aren't supported:
  • Matrix
  • Slicers
  • Q&A
  • Smart narratives
  • Metrics
  • Paginated reports
  • Power Apps
  • Power Automate
• It doesn't currently support streaming datasets
• There's a known issue when you attempt to save an Exploration from the Datamart SQL editor entry point

Related content

• Personalize visuals in a report
• Organizational licenses and subscriptions for Fabric and Power BI
• Power BI Premium Per User FAQ