Show data with Power BI reports
A Power BI visual is constructed using data from underlying datasets. If you're interested in seeing behind-the-scenes, the Power BI service lets you display the data that is being used to create a visual in a report. When you select Show as a table, Power BI displays the data below (or next to) the visual.
On a dashboard, to see the underlying data, use Export to Excel
Show the data being used to create a report visual
In the Power BI service, open a report and select a visual.
To display the data behind the visual, select More options (...) and choose Show as a table.
By default, the data displays below the visual.
To change the orientation, select vertical layout from the top-right corner of the visualization.
To return to the report, select Back to report from the upper left corner.