Microsoft Certified: Power Platform App Maker Associate Power BI Integration and Data Visualization 1 — Questions and Answers
Question 1: How can a maker embed a Power BI report inside a model-driven Power App?
- By adding a Power BI Embedded Dashboard or report as a dashboard component or using the Power BI tile in a form (Correct answer)
- By exporting the report to PDF and attaching it to a record
- By adding an iframe with the report URL in a canvas app
- By installing a Power BI connector in Dataverse
Correct answer: By adding a Power BI Embedded Dashboard or report as a dashboard component or using the Power BI tile in a form
Power BI reports and dashboards can be embedded in model-driven apps as personal or system dashboards, or as controls on forms, using the built-in Power BI integration.
Question 2: What is a Power BI 'workspace'?
- A collaborative container in Power BI service where reports, datasets, and dashboards are organized and shared with teammates (Correct answer)
- A local Power BI Desktop file storage location
- A virtual machine hosting Power BI Gateway
- A section inside a Power BI report for a specific department
Correct answer: A collaborative container in Power BI service where reports, datasets, and dashboards are organized and shared with teammates
Workspaces are shared environments in Power BI service where teams publish, organize, and collaborate on reports, dashboards, and datasets.
Question 3: What is the difference between a Power BI 'report' and a Power BI 'dashboard'?
- A report has multiple pages with detailed visuals from one dataset; a dashboard is a single page of pinned tiles from multiple reports (Correct answer)
- A report is shared with specific users; a dashboard is public
- A report uses live data; a dashboard uses cached data only
- A report is created in Power BI Desktop; a dashboard is created in Excel
Correct answer: A report has multiple pages with detailed visuals from one dataset; a dashboard is a single page of pinned tiles from multiple reports
Reports provide detailed multi-page analysis tied to a single dataset, while dashboards consolidate key visuals (pinned tiles) from multiple reports into a single monitoring view.
Question 4: In Power BI, what is 'DAX'?
- Data Analysis Expressions — a formula language used to create calculated columns, measures, and tables (Correct answer)
- Direct Access Exchange — a protocol for live database connections
- Data Aggregation XML — a schema for dataset definitions
- Dashboard Analytics Extension — a Power BI add-in
Correct answer: Data Analysis Expressions — a formula language used to create calculated columns, measures, and tables
DAX is the formula language in Power BI (and Analysis Services/Excel Power Pivot) used to write calculated measures and columns that perform aggregation and business logic.
Question 5: What does 'Row-level security' (RLS) do in Power BI?
- Restricts the data rows that specific users or roles can see in a report based on filter rules (Correct answer)
- Encrypts individual rows in the Power BI dataset
- Prevents users from exporting data from a report
- Limits the number of rows a dataset can contain
Correct answer: Restricts the data rows that specific users or roles can see in a report based on filter rules
RLS in Power BI applies DAX filter expressions to roles, ensuring each user only sees the rows of data they are authorized to view when the report is published.
Question 6: What is a Power BI 'measure'?
- A dynamic DAX calculation that aggregates data at query time based on the current filter context (Correct answer)
- A static calculated column stored in the dataset
- A KPI card visual in a report
- A row count statistic shown in the data model view
Correct answer: A dynamic DAX calculation that aggregates data at query time based on the current filter context
Measures are DAX expressions that calculate results dynamically in response to slicers, filters, and visual context, enabling flexible aggregations like total sales or year-over-year growth.
Microsoft Certified: Power Platform App Maker Associate Power BI Integration and Data Visualization 1
How can a maker embed a Power BI report inside a model-driven Power App?