Show the data that was used to create the visualization
A Power BI visualization is constructed using data from your datasets. If you're interested in seeing behind-the-scenes, Power BI lets you display the data that is being used to create the visual. When you select Show Data, Power BI displays the data below (or next to) the visualization.
You can also export the data that is being used to create the visualization as an .xlsx or .csv file and view it in Excel. For more information, see Export data from Power BI visualizations.
Show Data and Export Data are both available in Power BI service and Power BI Desktop. However, Power BI Desktop provides one additional layer of detail; Show Records displays the actual rows from the dataset.
Using Show Data in Power BI service
- In Power BI service, open a report in Reading view or Editing view, and select a visual. In Power BI Desktop, open Report view.
To display the data behind the visual, select Explore > Show data.
By default, the data displays below the visual.
To change the orientation, select vertical layout from the top-right corner of the visualization.
To export the data to a .csv file, select the ellipses and choose Export data.
For more information on exporting the data to Excel, see Export data from Power BI visualizations.
- To hide the data, de-select Explore > show data.