Dashboards vs reports in Power BI - Practice Questions

Challenge - 5 Problems

🧠 Conceptual

intermediate

Key difference between dashboards and reports

Which statement best describes the main difference between a dashboard and a report in Power BI?

A A dashboard is a single page that shows visuals from multiple reports, while a report can have multiple pages with detailed data.

B A report is a single page with visuals from multiple dashboards, while a dashboard can have multiple pages with detailed data.

C Dashboards and reports are exactly the same in Power BI, just different names.

D Reports only show data summaries, while dashboards only show raw data tables.

💡 Hint

Think about how many pages each can have and where visuals come from.

Dashboards are single pages that can combine visuals from different reports. Reports can have multiple pages and show detailed data.

🎯 Scenario

intermediate

Choosing between dashboard and report for monitoring sales

You want to monitor daily sales trends and quickly spot issues. You also want to drill down into detailed sales data when needed. Which Power BI feature should you primarily use?

A Create multiple dashboards for each sales region without reports.

B Create a single-page report with all visuals and no drill-down options.

C Use Excel instead of Power BI for this task.

D Create a dashboard with tiles linking to detailed reports for drill-down.

💡 Hint

Think about combining quick overview and detailed data access.

Dashboards provide quick overview with tiles, and linking to reports allows detailed drill-down.

❓ visualization

advanced

Best visualization practice for dashboards

Which visualization approach is best for a Power BI dashboard designed for executives to get quick insights?

A Use detailed tables with many columns and rows to show all data.

B Use simple, clear visuals like cards and gauges with minimal text and colors.

C Use many different chart types with bright colors and animations.

D Use only pie charts for all data points regardless of data type.

💡 Hint

Think about what helps quick understanding without overload.

Executives need clear, simple visuals that highlight key metrics quickly. Cards and gauges work well.

🔧 Formula Fix

advanced

Why does a dashboard tile not update with report changes?

You updated a report visual, but the linked dashboard tile still shows old data. What is the most likely reason?

A The report visual was deleted but the dashboard tile was not updated.

B The report data source is disconnected from Power BI service.

C The dashboard tile is pinned as a snapshot and does not auto-refresh with report changes.

D The dashboard tile is set to auto-refresh every minute.

💡 Hint

Think about how dashboard tiles update after pinning.

Dashboard tiles pinned as snapshots do not update automatically when the report changes. They need to be repinned or refreshed.

❓ data_modeling

expert

Optimizing data model for dashboards and reports

You have a large sales dataset. To improve dashboard load speed and report interactivity, which data modeling approach is best?

A Create aggregated tables for dashboards and detailed tables for reports, using relationships to connect them.

B Use a single detailed table for both dashboards and reports without aggregation.

C Duplicate all data in separate datasets for dashboards and reports.

D Remove all relationships to speed up loading.

💡 Hint

Think about balancing detail and performance.

Aggregated tables reduce data volume for dashboards, improving speed, while detailed tables support report drill-down. Relationships keep data connected.