Power BI Integration and Data Visualization Flashcards
6 cards from real Microsoft Certified: Power Platform App Maker Associate practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Power BI Integration and Data Visualization flashcards as text
What is the Power BI 'On-premises data gateway' used for?
Answer: Connecting Power BI service to data sources that are behind a corporate firewall or on-premises servers
The on-premises data gateway acts as a secure bridge that allows Power BI service (cloud) to query on-premises data sources like SQL Server or Oracle databases.
In Power BI Desktop, what is 'Power Query' used for?
Answer: Connecting to, transforming, and loading data from multiple sources into the data model before building visuals
Power Query (the Get Data / Transform Data experience) provides an M-language-based ETL environment for shaping and combining data before it enters the report's data model.
What is the purpose of a 'slicer' visual in Power BI?
Answer: To filter other visuals on the report page based on a selected value or range
Slicers are interactive filter controls placed on the report canvas that let users select values to filter all connected visuals on the page or across pages.
In Power BI, what does 'DirectQuery' mode mean for a dataset?
Answer: Power BI queries the source database directly at report load time rather than importing data into the model
In DirectQuery mode, Power BI sends queries to the underlying data source each time a visual is rendered, ensuring up-to-date data but relying on source performance.
What is a Power BI 'app' (App workspace app)?
Answer: A packaged collection of dashboards and reports published from a workspace for broader distribution to end users
Power BI apps bundle selected reports and dashboards from a workspace into a polished, version-controlled package that can be distributed to large audiences without giving access to the workspace itself.
In Power BI, what is 'drill-through'?
Answer: A navigation technique allowing users to right-click a data point and jump to a detail page filtered by that value
Drill-through lets report designers create a target page that receives filter context from a selected value, allowing users to jump to a detailed view of a specific item.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Passing score, score release, renewal, eligibility, retake policy, time limit · verified Oct 2026
- home.pearsonvue.com — Test delivery · verified Oct 2026