PL-200 · Question #265
A company uses Power BI dashboards. A manager wants to understand the raw data in one of the charts. You need to present the data. What should you do?
The correct answer is B. Export the dashboard to Microsoft Excel. To view the raw underlying data behind a Power BI chart, exporting to Excel is the correct approach because it extracts the tabular data that powers the visual.
Question
Options
- AExport the dashboard to Microsoft PowerPoint.
- BExport the dashboard to Microsoft Excel.
- CChange to focus mode.
- DDrill down in the dashboard controls.
How the community answered
(36 responses)- B92% (33)
- C6% (2)
- D3% (1)
Why each option
To view the raw underlying data behind a Power BI chart, exporting to Excel is the correct approach because it extracts the tabular data that powers the visual.
Exporting to PowerPoint creates a static image snapshot of the visual and does not expose the underlying raw data.
Exporting a Power BI dashboard or report to Excel extracts the underlying dataset into a spreadsheet, giving the manager direct access to the raw tabular data behind the chart. This is the purpose-built method for inspecting raw values rather than aggregated visuals. Other export formats do not expose the data in an editable or analyzable table format.
Focus mode enlarges a single visual for easier viewing but does not reveal or export the raw data behind the chart.
Drill down navigates to more granular visual levels within the chart hierarchy but does not present the raw data in tabular form.
Concept tested: Power BI export raw data to Excel
Source: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-export
Topics
Community Discussion
No community discussion yet for this question.