The dataset details page helps you explore, monitor, and leverage datasets. When you click on a dataset in the data hub, a workspace, or other place in Power BI, the details page for that dataset opens. 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.
In what ways are dataset details helpful?
- 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.
- Preview underlying data in a dataset, select tables and columns from the dataset and export or customize data to create a new table. ¹
¹ New feature – preview data
To preview data from dataset details page, you can select data from dataset’s tables on the side panel. If you do not see a side panel, click on “Show tables” from the action bar.
|Show tables||Opens a side panel showing the dataset’s tables. In the tables view you can create table previews by selecting desired columns. See picture below.|
The parent checkbox on the dataset’s table will indicate if all been selected, or only partially selected. Previews may not show all of the data you’ve selected. To see more, you can export or customize the newly created table.
The exported report is saved to your default downloads folder.
Clicking ‘Customize’ will maintain your current selection and open it in formatted table, where you can apply table styles, change aggregates, or save it as a Paginated report to a workspace.
Paginated reports add rich export capabilities to any of the supported formats, preserving full fidelity.
Preview data is a cool feature that allows you to leverage datasets and gain insights. Do you have other ideas about using formatted tables? Join our panel. We would love to hear from you!