Show data with Power BI reports
Power BI service for business users Power BI service for designers & developers 
Power BI Desktop Requires Pro or Premium license
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.
