CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

Power BI mock test: free online practice

15 to 30 random questions in 15 to 30 minutes, by the level you choose: power query, modelling, dax, calculate, time intelligence and rls. After you submit you get your score, your strong and weak topics, and the right answer with an explanation for every question.

Want to revise first? Read the Power BI interview questions and answers.

Choose your experience

Free with a CoreHRx Jobs account: you will be asked to sign in or create one first.

What does the Power BI mock test cover?

The test covers 12 topics across three levels. Each attempt picks 15 to 30 questions at random, by the level you choose, so every attempt is different.

  • DAX Basics
  • Filter Context and CALCULATE
  • Power Query
  • Data Modelling
  • Relationships
  • Service, Refresh and Gateways
  • Time Intelligence
  • Visuals and Reports
  • Row-Level Security
  • Performance Optimization
  • Power BI Basics
  • Sharing and Workspaces

Sample Power BI mock test questions

One question from each level, the way they appear in the test. A new set comes on the 1st of every month. Try it, then open the answer.

  1. FresherVisuals and Reports

    Which visual fits best for showing monthly sales over two years as a trend?

    • Pie chart with one slice for each of the months
    • Card that shows the latest month only
    • Treemap with one box for each month
    • Line chart with the months on the x-axis
    Show the answer

    Answer: Line chart with the months on the x-axis. Line charts show change over time and make trends, seasonality and dips easy to see. A pie or treemap with 24 parts compares parts of a whole and hides the order of months, and a card shows only one number.

  2. Intermediate (1-5 years)Relationships

    What does a many-to-many (*:*) relationship between Sales and Targets on Category do?

    • Duplicates every Sales row once for each matching row in Targets at refresh
    • Combines both tables into a single table during each refresh
    • Works only after both Category columns have been made unique
    • Filters by matching Category values even though neither column is unique
    Show the answer

    Answer: Filters by matching Category values even though neither column is unique. A *:* relationship matches values without needing a unique side, useful when two facts share a column such as Category. It is a limited relationship: no blank row is added and RELATED cannot follow it.

  3. Experienced (5+ years)Row-Level Security

    UserRegion (Email, RegionKey) maps managers to several regions and is on the many side of its link to Region. A role filter [Email] = USERPRINCIPALNAME() on UserRegion does not restrict Sales. Why?

    • RLS filters are evaluated only once, at refresh time, not separately for each user
    • USERPRINCIPALNAME returns the display name of the user, not the email address
    • The filter on the many side does not reach Region without both-way security filtering
    • Role filters can only be placed on fact tables, never on small mapping tables like this
    Show the answer

    Answer: The filter on the many side does not reach Region without both-way security filtering. Filters flow from the one side to the many side, so a filter on UserRegion stops there. Either set that relationship to Both with Apply security filter in both directions, or put the rule on Region using the mapping table.

Take the full Power BI mock test: 15 to 30 questions and 15 to 30 minutes, by level.

How is the Power BI mock test scored?

A question counts as right only when you pick exactly the right option, or all the right options where it says so; a question left blank counts as wrong. Your score is the share of the test's questions you got right (15 to 30, by level). The result also scores every topic, so you know what to revise before the interview.

  • 75% or more in a topica strength
  • 50% to 74%worth a revision
  • Under 50%a topic to work on

Power BI mock test: questions people ask

Is the Power BI mock test free?

Yes. The Power BI mock test is free. You need a free CoreHRx Jobs account to start it, so your score and the topics to work on are saved.

How many questions are in the Power BI mock test?

It depends on the level: Fresher has 15 questions in 15 minutes, Intermediate has 20 questions in 20 minutes, Experienced has 30 questions in 30 minutes. They are multiple-choice questions picked at random from a larger bank of Power BI questions at your level, so every attempt is different.

Which Power BI topics does the test cover?

The questions cover DAX Basics, Filter Context and CALCULATE, Power Query, Data Modelling, Relationships, Service, Refresh and Gateways, Time Intelligence, Visuals and Reports, Row-Level Security, Performance Optimization, Power BI Basics, Sharing and Workspaces. Your result shows how you did in each topic.

Which level should I choose?

Fresher if you are a student or have less than a year of experience, Intermediate for 1 to 5 years at work, and Experienced for 5 years or more.

Can employers see my Power BI score?

Only your best Power BI score, and only when it is 60% or more. It shows on the job applications you send on CoreHRx. Lower scores stay private.

Can I take the Power BI mock test again?

Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.

All mock tests