Power BI interview questionsTechnical interview questions
← 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
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

Beginner 9 questions

1On shared (Pro) capacity, the maximum SCHEDULED refreshes per day is…

  1. 4
  2. unlimited
  3. 48
  4. 8
  5. 24
Show answerHide answer

D · 8 Pro/shared allows 8 scheduled refreshes/day; Premium/PPU allows up to 48.

2A Power BI 'App' is…

  1. A dashboard tile
  2. A mobile-only report
  3. A dataset
  4. A gateway
  5. 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…

  1. Refresh on-premises (or some cloud) data sources
  2. Publish a report
  3. Apply RLS
  4. Share a dashboard
  5. 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…

  1. A dataflow
  2. A dataset
  3. A multi-page report
  4. A single-page canvas of pinned tiles
  5. 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?

  1. Dual
  2. Direct Lake
  3. Composite
  4. Import
  5. 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…

  1. A personal workspace
  2. Any workspace
  3. Premium capacity (Premium/PPU/Fabric F SKU)
  4. OneDrive
  5. 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?

  1. Rules authored in Power BI Desktop; members assigned in the Service
  2. In the gateway
  3. In the mobile app
  4. Only in Excel
  5. 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…

  1. Manage gateways
  2. Schedule refresh
  3. Assign RLS
  4. Ask natural-language questions of the model
  5. 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…

  1. Secured by Azure AD
  2. Password protected
  3. Public — anyone with the link can view, no security
  4. Expiring in 24h
  5. 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?

  1. unlimited
  2. 2
  3. 5
  4. 4
  5. 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…

  1. CURRENTUSER()
  2. ME()
  3. USERPRINCIPALNAME()
  4. USEROBJECTID()
  5. 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…

  1. Faster visuals
  2. Free sharing
  3. External tools to read/write the semantic model
  4. Automatic RLS
  5. 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…

  1. Reviewed and endorsed by authorized reviewers as trustworthy
  2. Larger
  3. Newer
  4. Read-only
  5. 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…

  1. Refreshing the whole model faster by luck
  2. Disabling folding
  3. Caching visuals
  4. Refreshing only recent partitions, saving time and resources
  5. 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…

  1. Removing relationships
  2. Disabling the cache
  3. Blocking DirectQuery
  4. Always importing everything
  5. 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) …

  1. Only change colors
  2. Replace RLS
  3. Speed up refresh
  4. Classify and protect content, persisting to exports like Excel/PDF
  5. 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…

  1. Allows models to grow beyond the default size limit
  2. Adds a gateway
  3. Disables RLS
  4. Compresses visuals
  5. 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 →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More technical interview questions