By Michele Hart
Sunday, January 22, 2017
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 See 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.
See 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; See Records displays the actual rows from the dataset.
To see the data behind the visual, select Explore > See data.
By default, the data displays below the visual. To change this, in the top right corner of the visual, select the Switch to vertical layout icon .
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 change the display to a vertical orientation, select the Switch to vertical layout icon .
To hide the data, de-select Explore > See data.
More questions? Try the Power BI Community