Semantic model details

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

The semantic model details page:

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

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

Supported actions

The semantic model 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 semantic model.	File > Download this file
Manage permissions	Opens the manage semantic model permissions page.	File > Manage permissions
Settings	Opens the semantic model settings page.	File > Settings
Refresh now	Launches a refresh of the semantic model.	Refresh > Refresh now
Schedule refresh	Opens the semantic model settings page where you can set scheduled refresh.	Refresh > Schedule refresh
Share	Opens the Share semantic model 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 semantic model.	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 semantic model.	Analyze in Excel
Open lineage view	Opens the lineage view for the semantic model.	Lineage > Open lineage view
Impact analysis	Opens the impact analysis side pane for this semantic model.	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 semantic model details page. If they have access to the semantic model, the link will open this semantic model details page in Teams.	Chat in Teams
Show tables	Opens a side panel showing the semantic model's tables. In the tables view you can create table previews by selecting desired columns.	Show tables

View semantic model metadata

The semantic model 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.

Explore related reports

The explore related reports section shows you all the reports and scorecards that are built on the semantic model. 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.

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 semantic model, select the Create report button on this tile and choose the desired option.

• Auto-create: Creates an auto-generated report from the semantic model.
• 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 semantic model. When you save your new report, it will be saved in the workspace that contains the semantic model 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 semantic model resides in a Premium-capacity workspace, the new report will be saved in My workspace.
• As formatted table: Opens the formatted table editing canvas.

Note

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

Share this data

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

Data preview

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

Prerequisites

• The semantic model can be inside Premium or non-Premium workspaces. Classic workspaces aren't supported. Read about new and classic workspaces.
• You need Build permission for the semantic model.

Select data to preview

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

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

An entirely filled parent checkbox on the semantic model'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.

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

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.

Back

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

Note

Table preview is intended to quickly explore the underlying data of tables within your semantic model. 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.

Build a paginated report

Select the Create paginated report button to open the editor.

Note

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.

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.

Considerations and limitations

Streaming datasets do not have a details page.

Related content

• Use semantic models across workspaces
• Create reports based on semantic models from different workspaces
• Endorse your semantic model
• Questions? Try asking the Power BI Community