Power BI Service
Power BI Administration
Data Prep & Transformation
Data Modeling
Data Visualization
100

This advanced feature in Power BI Service enables you to create and manage roles and rules to restrict data access for different users.

What is row-level-security?

100

This feature allows administrators to manage user access and permissions within the Power BI service.

What is 'User Management'?

100

This tool is used to connect, combine, and refine data across various sources for analysis.

What is power query?

100

This language is used to create calculated columns, measures, and custom tables in Power BI.

What is DAX?

100

This type of chart is commonly used to show trends over time.

What is a line chart?

200

This feature allows you to create a collection of related dashboards, reports, and datasets that can be shared and managed together in Power BI Service.

What is an 'app'?

200

This setting in Power BI allows you to control which users can publish content to the Power BI service.

What is ‘Publish Permissions’?

200

This operation combines rows from multiple tables into a single table, while this operation combines columns based on a common column.

What are ‘Append Queries’ and ‘Merge Queries’?

200

This type of table is used to store data that describes business entities and is often used in star schema models.

What is a dimension table?

200

This feature allows you to apply a consistent color scheme across all visuals in a Power BI report.

What is 'Themes'?

300

This feature allows you to create a live connection to a dataset in Power BI Service, enabling real-time data updates in your reports.

What is Direct Query?


300

This feature enables administrators to monitor and manage the performance and usage of Power BI reports and dashboards across the organization.

What is ‘Power BI Admin Portal’?

300

This feature aggregates data by grouping rows with the same value in specified columns and performing operations like sum, average, or count.

What is the Group By feature?

300

This feature in Power BI allows you to create a new column in a table by using a DAX formula.

What is the calculated column feature?

300

This type of visualization is used to display the distribution of data across different categories, often using bars of varying heights.

What is a histogram?

400

This feature allows you to control which users can view or interact with specific data within a report, based on their role.

What is role-based access control?

400

This security feature allows you to enforce data protection policies and ensure compliance with organizational standards.

What is ‘Data Loss Prevention (DLP)’?

400

This feature allows you to transform the data layout by converting columns to rows or vice versa.

What is the ‘Pivot/Unpivot Columns’ feature?

400

This advanced DAX function is used to iterate over a table and return a single value by applying a specified expression to each row.

What is the 'SUMX' function?

400

This advanced visualization technique allows you to display hierarchical data in a compact, space-efficient format, often used for showing part-to-whole relationships.

What is a treemap?

500

This feature allows you to monitor the performance and user activity of your Power BI reports and dashboards, providing insights into how they are being used.

What is ‘Power BI Usage Metrics’?


500

This advanced feature allows administrators to automate the deployment and management of Power BI assets using scripts and APIs.

What is ‘Power BI REST API’?

500

This feature allows you to divide a column into multiple columns using a delimiter or a fixed number of characters.

What is the Split Column feature?

500

This DAX function is used to create a virtual table by applying a set of filters and then performing calculations on that table, often used in complex scenarios involving multiple conditions and relationships.

What is the 'SUMMARIZE' function?

500

This feature in Power BI allows you to create interactive reports by linking multiple visuals so that selecting data in one visual filters the data in others.

What is cross filtering?