← Interview & exam prep
Technical interview questions
Power BI interview questions
17 questions from beginner to advanced, each with the correct answer and a one-line explanation of why. Study them here, or take them as a timed test.
17 questionsBeginner 9 · Intermediate 8Answers + explanations
Beginner 9 questions
1On shared (Pro) capacity, the maximum SCHEDULED refreshes per day is…
- 4
- unlimited
- 48
- 8
- 24
Show answerHide answer
D · 8 Pro/shared allows 8 scheduled refreshes/day; Premium/PPU allows up to 48.
2A Power BI 'App' is…
- A dashboard tile
- A mobile-only report
- A dataset
- A gateway
- A packaged, distributable bundle of reports/dashboards from a workspace
Show answerHide answer
E · A packaged, distributable bundle of reports/dashboards from a workspace Apps package workspace content for easy, governed distribution to consumers.
3An on-premises data gateway is required to…
- Refresh on-premises (or some cloud) data sources
- Publish a report
- Apply RLS
- Share a dashboard
- Create a measure
Show answerHide answer
A · Refresh on-premises (or some cloud) data sources The gateway bridges the Service to data behind a corporate firewall for refresh/DirectQuery.
4A dashboard (as opposed to a report) is…
- A dataflow
- A dataset
- A multi-page report
- A single-page canvas of pinned tiles
- A workspace
Show answerHide answer
D · A single-page canvas of pinned tiles Dashboards are single-page and made of tiles pinned from reports/other sources.
5Which storage mode keeps data in the source and queries it live at runtime?
- Dual
- Direct Lake
- Composite
- Import
- DirectQuery
Show answerHide answer
E · DirectQuery DirectQuery leaves data at the source and issues live queries per interaction.
6To let users WITHOUT a Pro license consume your content, it must live in…
- A personal workspace
- Any workspace
- Premium capacity (Premium/PPU/Fabric F SKU)
- OneDrive
- A gateway
Show answerHide answer
C · Premium capacity (Premium/PPU/Fabric F SKU) Free users can only consume content hosted on Premium/Fabric capacity.
7Row-level security roles are defined and assigned where?
- Rules authored in Power BI Desktop; members assigned in the Service
- In the gateway
- In the mobile app
- Only in Excel
- Only in the Service
Show answerHide answer
A · Rules authored in Power BI Desktop; members assigned in the Service You write RLS rules in Desktop and map users/groups to roles in the Service.
8The Q&A visual lets users…
- Manage gateways
- Schedule refresh
- Assign RLS
- Ask natural-language questions of the model
- Edit DAX
Show answerHide answer
D · Ask natural-language questions of the model Q&A turns plain-language questions into visuals against the semantic model.
9'Publish to web' produces a link that is…
- Secured by Azure AD
- Password protected
- Public — anyone with the link can view, no security
- Expiring in 24h
- Read-only for your org
Show answerHide answer
C · Public — anyone with the link can view, no security Publish to web is fully public; never use it for confidential data.
Intermediate 8 questions
10A deployment pipeline has how many stages?
- unlimited
- 2
- 5
- 4
- 3 (Development, Test, Production)
Show answerHide answer
E · 3 (Development, Test, Production) Deployment pipelines have exactly three stages: Development, Test, Production.
11For dynamic RLS, the recommended function to return the signed-in user is…
- CURRENTUSER()
- ME()
- USERPRINCIPALNAME()
- USEROBJECTID()
- USERNAME()
Show answerHide answer
C · USERPRINCIPALNAME() USERPRINCIPALNAME() returns the UPN reliably in the Service; USERNAME can return DOMAIN\user on Desktop.
12The XMLA endpoint (Premium) allows…
- Faster visuals
- Free sharing
- External tools to read/write the semantic model
- Automatic RLS
- Mobile layouts
Show answerHide answer
C · External tools to read/write the semantic model XMLA lets tools like Tabular Editor/SSMS connect to and edit the model.
13'Certified' endorsement (vs 'Promoted') means the content is…
- Reviewed and endorsed by authorized reviewers as trustworthy
- Larger
- Newer
- Read-only
- In production
Show answerHide answer
A · Reviewed and endorsed by authorized reviewers as trustworthy Certification is a stronger, governed endorsement granted by designated reviewers.
14Incremental refresh mainly helps by…
- Refreshing the whole model faster by luck
- Disabling folding
- Caching visuals
- Refreshing only recent partitions, saving time and resources
- Removing RLS
Show answerHide answer
D · Refreshing only recent partitions, saving time and resources Only changed/recent partitions refresh, so large models refresh far faster.
15Composite models with aggregations improve performance by…
- Removing relationships
- Disabling the cache
- Blocking DirectQuery
- Always importing everything
- Answering from pre-aggregated import tables and falling back to DirectQuery for detail
Show answerHide answer
E · Answering from pre-aggregated import tables and falling back to DirectQuery for detail Aggregation tables serve summary queries from memory; detail queries fold to the source.
16Sensitivity labels (Microsoft Information Protection) …
- Only change colors
- Replace RLS
- Speed up refresh
- Classify and protect content, persisting to exports like Excel/PDF
- Are Fabric-only
Show answerHide answer
D · Classify and protect content, persisting to exports like Excel/PDF MIP labels travel with the content and enforce protection even after export.
17Enabling 'Large dataset storage format' in Premium…
- Allows models to grow beyond the default size limit
- Adds a gateway
- Disables RLS
- Compresses visuals
- Turns on DirectQuery
Show answerHide answer
A · Allows models to grow beyond the default size limit It unlocks larger in-memory models (and XMLA write) on Premium/PPU capacity.
What changed lately? Latest Power BI Service news, releases & questions →
More technical interview questions