Dataset details

The dataset details page helps you explore, monitor, and leverage datasets. When you select a dataset in the data hub, a workspace, or other place in Power BI, the details page for that dataset opens.

Screenshot of dataset details page.

The dataset details page:

  • Shows you metadata about the dataset, including description, endorsement, and sensitivity.
  • Provides actions that you can perform on the dataset, such as share, refresh, create new, Analyze in Excel, and more.
  • Lists the reports and scorecards that are built on top of the dataset.

The page header displays the dataset name, endorsement (if any), and dataset owner. To send an email to the dataset owner or the dataset certifier (if any), select the header and then select the name of the owner.

Supported actions

The dataset details page enables you to perform a number of actions. The actions available vary from user to user depending on their permissions on the data item, and thus not all actions are available for all users.

Action Description On Action bar, choose:
Download this file Downloads the .pbix file for this dataset. File > Download this file
Manage permissions Opens the manage dataset permissions page. File > Manage permissions
Settings Opens the dataset settings page. File > Settings
Refresh now Launches a refresh of the dataset. Refresh > Refresh now
Schedule refresh Opens the dataset settings page where you can set scheduled refresh. Refresh > Schedule refresh
Share Opens the Share dataset dialog. Share, or use the Share this data tile.
Create a report from scratch Opens the report editing canvas where you can create a new report based on the dataset. Create a report > From scratch, or use the Visualize this data tile.
Create a report from template Creates a copy of the template in My Workspace. This action is only available if a related report template exists. Create a report > From template, or use the Visualize this data tile.
Create a report as formatted table Opens the formatted table editing canvas. Create a report > As formatted table, or use the Visualize this data tile.
Analyze in Excel Launches Analyze in Excel using this dataset. Analyze in Excel
Open lineage view Opens the lineage view for the dataset. Lineage > Open lineage view
Impact analysis Opens the impact analysis side pane for this dataset. Lineage > Impact analysis
Chat in Teams Invite people to start chatting in Teams. People you invite will receive a Teams chat message from you with a link to this dataset details page. If they have access to the dataset, the link will open this dataset details page in Teams. Chat in Teams
Show tables Opens a side panel showing the dataset's tables. In the tables view you can create table previews by selecting desired columns. Show tables

View dataset metadata

Screenshot of dataset details section on data details page.

The dataset details section shows:

  • The name of the workspace where the item is located.
  • The exact time of the last refresh.
  • Endorsement status and certifier (if certified).
  • Sensitivity (if set).
  • Description (if any). You can create or edit the description from here.

The explore related reports section shows you all the reports and scorecards that are built on the dataset. You can create a copy of an item by selecting the line the item is on and selecting the Save a copy icon that appears. This section also shows you usage metrics for the related items.

Screenshot of explore related reports section on dataset details page.

The columns in the list of related reports are:

  • Name: Report name. If the name ends with (template), it means that this report has been specially constructed to be used as a template. For example, "Sales (template)".
  • Type: Item type, for example, report or scorecard.
  • Endorsement: Endorsement status.
  • Workspace: The name of the workspace where the related item is located.
  • Unique viewers: Shows the total number of unique users who viewed the item at least once in the last 30 days, excluding the current day's views.
  • Views: Shows the total number of times an item was viewed in the last 30 days, excluding the current day's views.

Visualize this data

To create a report based on the dataset, select the Create report button on this tile and choose the desired option.

Screenshot of visualize this data section on data details page.

  • Auto-create: Creates an auto-generated report from the dataset.
  • From template: Creates a copy of the template in My workspace.
  • From scratch: Opens the report editing canvas to a new report built on the dataset. When you save your new report, it will be saved in the workspace that contains the dataset if you have write permissions on that workspace. If you don't have write permissions on the workspace, or if you are a free user and the dataset resides in a Premium-capacity workspace, the new report will be saved in My workspace.
  • As formatted table: Opens the formatted table editing canvas.


Only one template will be shown in the Create report drop-down, even if more than one report template exists for this dataset.

Share this data

You can share the dataset with other users in your organization. Selecting the Share dataset button opens the Share dataset dialog, where you can choose which permissions to grant on the dataset.

Screenshot of datamart share this data section on data details page.

Data preview

Data preview enables you to view a selected table or columns from the dataset. You can also export the data to supported file formats or create a paginated report.


Select data to preview

To preview a datasets's data from the dataset details page, select a table or columns on the Tables side panel.

Screenshot of the Tables side panel on the dataset details page.

If you don't see the side panel, select Show tables on the action bar.

Screenshot of Show tables option on Dataset details page.

An entirely filled parent checkbox on the dataset's table indicates that all its sub-tables and columns have been selected. A partially filled parent checkbox means that only a subset of them has been selected.

Screenshot showing all columns selected.

When you select a table or columns in a table, they will be displayed on the Table preview page that opens.

Screenshot showing table preview page.

Table preview may not show all of the data you've selected. To see more, you can export or build a paginated report.

You can resize column widths using a drag handle next to the column headers. Resizing columns can make the table preview more readable, especially for long column input values.

Show query

Show query enables you to copy the DAX query used to create the table preview to the clipboard. This makes it possible to reuse the query for future actions.

Screenshot showing table preview with the query displayed.


At any time you can return to the dataset details page by selecting the Back button on the action bar. Selecting the Back button clears all your selections and brings you back to dataset details page.


Table preview is intended to quickly explore the underlying data of tables within your dataset. You cannot view measures or select more than one table or columns across tables. You can select Create paginated report for that.

Export data

Select the Export button on the Table preview page to export the data to one of the supported file formats.

Screenshot showing table preview export option.

Build a paginated report

Select the Create paginated report button to open the editor.


Data will change from underlying data to summarized data. You can switch to underlying data using More options.

In the editor you can select multiple tables, measure, fields across tables, apply table styles, change aggregates, and so on.

Screenshot showing formatted table editor.

You can then export the report to any of the supported file formats, and the file will be saved to your default downloads folder. Or you can save it as a paginated report to a workspace of your choice. Paginated reports fully preserve your report formatting.

Switch from summarized to underlying data in the editor

Select More options (...) to switch from Summarized data to Underlying data.

Screenshot showing more options.

Next steps