Show the data used to create a Power BI visualization

APPLIES TO: 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 show the data that's being used to create a visual in a report. When you select Show as a table, the data appears below (or next to) the visual.

You can also export the data to Excel for visuals in a report and visuals on a dashboard.

Show the data that creates a report visual

  1. In the Power BI service, open a report and select a visual.

  2. To show the data behind the visual, select More options (...) and choose Show as a table.

    Screenshot with Show as a table selected from the More options dropdown.

  3. By default, the data appears below the visual.

    Screenshot showing the visual with a table below it.

  4. To change the orientation, select vertical layout .

    Screenshot showing the visual with a table next to it.

To return to the report, select Back to report from the upper left corner.

Screenshot showing the Back to report button.

Next steps

Visuals in Power BI reports
Power BI reports