Search test library by skills or roles
⌘ K

About the test:

The Power BI test evaluates candidate's ability to build data models, select and execute appropriate visualizations, create dashboards to explore data and answer queries, publish and share insightful reports and run analytics using DAX language in Power BI.

Covered skills:

  • Connecting to data sources and importing
  • Data models
  • Themes and visualization
  • Publishing and sharing
  • Data wrangling and transformations
  • DAX formulas
  • Interactive reports
  • Power BI Desktop

9 reasons why
9 reasons why

Adaface Power BI Test is the most accurate way to shortlist Power BI Developers

Reason #1

Tests for on-the-job skills

The Power BI Online Test helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

  • Connecting to data sources and importing
  • Performing data wrangling and transformations
  • Creating and optimizing data models
  • Writing effective DAX formulas
  • Designing visually appealing themes and visualizations
  • Building interactive reports
  • Publishing and sharing reports
  • Utilizing Power BI Desktop efficiently
Reason #2

No trick questions

no trick questions

Traditional assessment tools use trick questions and puzzles for the screening, which creates a lot of frustration among candidates about having to go through irrelevant screening assessments.

View sample questions

The main reason we started Adaface is that traditional pre-employment assessment platforms are not a fair way for companies to evaluate candidates. At Adaface, our mission is to help companies find great candidates by assessing on-the-job skills required for a role.

Why we started Adaface
Reason #3

Non-googleable questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

How we design questions

These are just a small sample from our library of 10,000+ questions. The actual questions on this Microsoft Power BI Test will be non-googleable.

🧐 Question


Data Filtering
Report Development
M Language
Data Visualization
You are creating a Power BI report where users need to dynamically filter data based on a range of dates. The report has a Sales table with columns Date, ProductID, and Amount. You decide to use a Power Query parameter to allow users to select a start and end date, which will then filter the Sales table accordingly. The parameter is named DateRange and has a type of List. You need to write a Power Query M formula to filter the Sales table based on the selected date range. The DateRange parameter contains two dates: the first item is the start date, and the second item is the end date. How should the M formula be structured to achieve this functionality?
A: Table.SelectRows(Sales, each [Date] >= DateRange{0} and [Date] <= DateRange{1})

B: Sales{[Date] >= DateRange{0}, [Date] <= DateRange{1}}

C: Table.FilterRows(Sales, each [Date] >= List.First(DateRange) and [Date] <= List.Last(DateRange))

D: Table.SelectRows(Sales, each [Date] >= List.First(DateRange) and [Date] <= List.Last(DateRange))

E: Filter.Table(Sales, [Date] >= DateRange{0}, [Date] <= DateRange{1})


Many-to-one error
Data Modeling
Consider the following two tables in Power BI:
We received the following error when we tried to set many-to-one cardinality between devices to users tables: “The cardinality you selected isn’t valid for this relationship”. What should we do before creating the many-to-one relationship?


Power Query Functions
Power Query
Review the following Microsoft SQL Server table:
Complete the following Power Query formula used to create a custom column to replace the numbers present in last 11 characters of ISBN with 11 ‘*’. Example ‘978-0-365-51051-4’ is converted to ‘978-0-***-*****-*’
A: Text.Insert
B: Text.Replace
C: Text.Start
D: Text.End
🧐 Question🔧 Skill


Data Filtering
Report Development
M Language
Data Visualization

2 mins

Power BI


Many-to-one error
Data Modeling

2 mins

Power BI


Power Query Functions
Power Query

2 mins

Power BI
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Data Filtering
Report Development
M Language
Data Visualization
Power BI
Medium2 mins
Many-to-one error
Data Modeling
Power BI
Medium2 mins
Power Query Functions
Power Query
Power BI
Medium2 mins
Reason #4

1200+ customers in 75 countries

customers in 75 countries

With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!

Brandon Lee, Head of People, Love, Bonito

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment Microsoft Power BI Test in your hiring process is that it is an elimination tool, not a selection tool. In other words: you want to use the test to eliminate the candidates who do poorly on the test, not to select the candidates who come out at the top. While they are super valuable, pre-employment tests do not paint the entire picture of a candidate’s abilities, knowledge, and motivations. Multiple easy questions are more predictive of a candidate's ability than fewer hard questions. Harder questions are often "trick" based questions, which do not provide any meaningful signal about the candidate's skillset.

Science behind Adaface tests
Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the Microsoft Power BI Test from your dashboard by entering their email address.

Public link: You can create a public link for each test that you can share with candidates.

API or integrations: You can invite candidates directly from your ATS by using our pre-built integrations with popular ATS systems or building a custom integration with your in-house ATS.

invite candidates
Reason #7

Detailed scorecards & benchmarks

View sample scorecard
Reason #8

High completion rate

Adaface tests are conversational, low-stress, and take just 25-40 mins to complete.

This is why Adaface has the highest test-completion rate (86%), which is more than 2x better than traditional assessments.

test completion rate
Reason #9

Advanced Proctoring

Learn more

About the Power BI Assessment Test

Why you should use Pre-employment Power BI Online Test?

The Microsoft Power BI Test makes use of scenario-based questions to test for on-the-job skills as opposed to theoretical knowledge, ensuring that candidates who do well on this screening test have the relavant skills. The questions are designed to covered following on-the-job aspects:

  • Connecting to various data sources and importing data into Power BI
  • Performing data wrangling and transformations to clean and preprocess data
  • Creating and managing data models in Power BI
  • Writing and using DAX formulas for calculations and calculations in Power BI
  • Applying themes and visualizations to enhance the appearance of reports
  • Designing interactive reports with filters, slicers, and drill-through functionality
  • Publishing and sharing Power BI reports with stakeholders
  • Utilizing the Power BI Desktop application for report development
  • Implementing advanced data modeling techniques for complex business scenarios
  • Using advanced DAX functions and techniques for advanced calculations

Once the test is sent to a candidate, the candidate receives a link in email to take the test. For each candidate, you will receive a detailed report with skills breakdown and benchmarks to shortlist the top candidates from your pool.

What topics are covered in the Power BI Online Test?

  • Connecting to data sources and importing

    This skill involves the ability to connect Power BI to various data sources such as databases, spreadsheets, and online services, and import data into Power BI. It is important to measure this skill in the test to ensure that candidates are proficient in gathering data from different sources, a crucial step in creating insightful Power BI reports.

  • Data wrangling and transformations

    This skill focuses on the ability to clean and transform data within Power BI, including tasks such as filtering, sorting, merging, and shaping data. Testing this skill ensures that candidates can effectively manipulate data to meet the requirements of their analysis and reporting.

  • Data models

    This skill involves creating efficient and optimized data models within Power BI, including defining relationships between tables, creating hierarchies, and setting up measures. By measuring this skill, recruiters can evaluate a candidate's understanding of how to structure data for optimal performance and analysis in Power BI.

  • DAX formulas

    This skill assesses a candidate's knowledge of using the Data Analysis Expressions (DAX) language in Power BI to create calculated columns, measures, and other calculations. DAX formulas are essential for performing complex calculations and aggregations in Power BI, making it crucial to measure this skill in the assessment.

  • Themes and visualization

    This skill focuses on the ability to apply visual themes and create visually appealing and effective visualizations in Power BI. It is important to measure this skill as it ensures that candidates can design and present data in a visually appealing and meaningful way, enhancing the user experience of Power BI reports.

  • Interactive reports

    This skill measures a candidate's proficiency in creating interactive reports in Power BI, including using features such as drill-through, bookmarks, and report navigation. Testing this skill ensures that candidates can create dynamic and user-friendly reports that allow for effective data exploration and analysis.

  • Publishing and sharing

    This skill assesses a candidate's ability to publish and share Power BI reports with others, including sharing reports through the Power BI service, embedding reports in other applications, and managing permissions. Measuring this skill ensures that candidates are familiar with the process of making their Power BI reports accessible and shareable to stakeholders.

  • Power BI Desktop

    This skill covers the overall proficiency of a candidate in using the Power BI Desktop application, including tasks such as creating and editing reports, managing data connections, and implementing advanced functionalities. With Power BI Desktop being a central tool for Power BI development, it is crucial to assess a candidate's proficiency in this area.

  • Full list of covered topics

    The actual topics of the questions in the final test will depend on your job description and requirements. However, here's a list of topics you can expect the questions for Microsoft Power BI Test to be based on.

    Connecting to databases
    Importing from Excel
    Working with CSV files
    Handling multiple data sources
    Cleaning and reshaping data
    Filtering and sorting data
    Appending and merging data
    Normalizing and denormalizing tables
    Creating calculated columns
    Defining relationships between tables
    Optimizing data models
    Creating calculated measures
    Using DAX functions
    Implementing time intelligence
    Building hierarchies and aggregations
    Applying conditional formatting
    Customizing visual themes
    Designing interactive dashboards
    Creating drillthrough and drilldown functionality
    Utilizing page navigation
    Creating bookmarks and buttons
    Creating report-level filters
    Sharing reports via email
    Publishing reports to the web
    Collaborating with others on Power BI service
    Utilizing Power Query Editor
    Using Query Editor transformations
    Applying data loading options
    Creating calculated tables
    Working with advanced DAX functions
    Designing KPIs (Key Performance Indicators)
    Implementing row-level security
    Analyzing data with advanced visualizations
    Using advanced slicer options
    Implementing advanced drillthrough and drilldown
    Utilizing DirectQuery and Live Connection
    Building paginated reports
    Creating and using custom visuals
    Creating Power BI templates

What roles can I use the Power BI Online Test for?

  • Power BI Developer
  • Power BI Expert
  • Power BI Analyst
  • Power BI Data Engineer
  • Business Analyst
  • Senior Power BI Developer
  • Reporting Analyst
  • Power BI Administrator

How is the Power BI Online Test customized for senior candidates?

For intermediate/ experienced candidates, we customize the assessment questions to include advanced topics and increase the difficulty level of the questions. This might include adding questions on topics like

  • Leveraging the Power BI service for online collaboration and sharing
  • Optimizing performance and data refresh in Power BI reports
  • Creating and managing data gateways for on-premises data sources
  • Implementing Row-level Security (RLS) to restrict data access based on user roles
  • Configuring scheduled data refresh for automatic updates in Power BI
  • Utilizing advanced visualization techniques like custom visuals and storytelling
  • Creating and using Power BI apps for streamlined report distribution
  • Monitoring and analyzing usage statistics and insights in Power BI
Singapore government logo

The hiring managers felt that through the technical questions that they asked during the panel interviews, they were able to tell which candidates had better scores, and differentiated with those who did not score as well. They are highly satisfied with the quality of candidates shortlisted with the Adaface screening.

reduction in screening time

Power BI Hiring Test FAQs

Can I evaluate Power BI and SQL?

Yes. We support evaluating multiple skills in a single assessment. You can order a customized assessment that evaluates Power BI and SQL. You can review our standard SQL test here.

Can I evaluate Power BI and ETL in a single assessment?

Yes. We support evaluating multiple skills in a single assessment. You can order a customized assessment that evaluates Power BI and ETL. You can review our standard ETL test here.

Can I combine multiple skills into one custom assessment?

Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify. Here's a quick guide on how you can request a custom test.

Do you have any anti-cheating or proctoring features in place?

We have the following anti-cheating features in place:

  • Non-googleable questions
  • IP proctoring
  • Screen proctoring
  • Web proctoring
  • Webcam proctoring
  • Plagiarism detection
  • Secure browser
  • Copy paste protection

Read more about the proctoring features.

How do I interpret test scores?

The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

What experience level can I use this test for?

Each Adaface assessment is customized to your job description/ ideal candidate persona (our subject matter experts will pick the right questions for your assessment from our library of 10000+ questions). This assessment can be customized for any experience level.

Does every candidate get the same questions?

Yes, it makes it much easier for you to compare candidates. Options for MCQ questions and the order of questions are randomized. We have anti-cheating/ proctoring features in place. In our enterprise plan, we also have the option to create multiple versions of the same assessment with questions of similar difficulty levels.

I'm a candidate. Can I try a practice test?

No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

What is the cost of using this test?

You can check out our pricing plans.

Can I get a free trial?

Yes, you can sign up for free and preview this test.

I just moved to a paid plan. How can I request a custom assessment?

Here is a quick guide on how to request a custom assessment on Adaface.

customers across world
Join 1200+ companies in 75+ countries.
Try the most candidate friendly skills assessment tool today.
g2 badges
Ready to use the Adaface Microsoft Power BI Test?
Ready to use the Adaface Microsoft Power BI Test?
40 min tests.
No trick questions.
Accurate shortlisting.
Terms Privacy Trust Guide
● Online
Score: NA