60 Power BI Interview Questions and Answers

11. What are custom visuals in Power BI?

Custom visuals extend the visualizations available in Power BI. They may be downloaded from Microsoft AppSource, supplied by an organization, or created using the Power BI visuals SDK.

Before using a custom visual, teams should consider security, accessibility, performance, certification status, support, and whether a built-in visual could meet the same requirement.

12. What is Get Data in Power BI?

Get Data is the option used to connect Power BI to a source. Power BI supports connectors for files, databases, cloud platforms, online services, Power Platform products, and many other systems.

After selecting a source, users can either load the data or open Power Query by selecting Transform Data.

13. What are the advantages of Power BI?

Important advantages include:

• Integration with Microsoft products
• Connections to a wide range of data sources
• Interactive reports and dashboards
• Reusable semantic models
• DAX calculations
• Power Query transformations
• Row-level security
• Mobile access
• Scheduled and incremental refresh
• Collaboration through workspaces and apps

14. What are the limitations of Power BI?

Some limitations depend on the license, capacity, connection mode, and data source.

For example, Power BI Desktop runs on Windows. Import models are subject to model-size and capacity limits. DirectQuery reports depend heavily on the performance and availability of the source system. Some transformations and DAX operations are also restricted or less efficient in DirectQuery mode.

Sharing, refresh frequency, deployment, and enterprise governance capabilities may require paid licenses or Fabric capacity.

15. Which certification is relevant to Power BI interviews?

The Microsoft Certified: Power BI Data Analyst Associate credential is associated with the PL-300 exam.

The exam covers preparing data, modeling data, visualizing and analyzing data, and managing Power BI. A certification can support a candidate’s profile, but interviewers will still expect practical knowledge of Power Query, DAX, data modeling, reporting, and the Power BI service.

Intermediate Power BI Interview Questions on DAX, Power Query, and Data Modeling

16. How would you handle missing data in Power BI?

The correct approach depends on why the values are missing and how the business intends to use the data.

Possible actions include:

• Identifying nulls with Power Query data profiling
• Replacing nulls with an appropriate default value
• Filling values from previous or subsequent rows
• Removing incomplete rows when their absence does not distort the analysis
• Creating an “Unknown” category
• Flagging missing records for review
• Correcting the issue in the source system

Candidates should explain the business impact of the chosen approach rather than automatically replacing every null with zero.

17. What connectivity and storage modes are available in Power BI?

The principal semantic model modes are Import, DirectQuery, and Composite.

Import is normally the fastest option for report users. DirectQuery is useful when data cannot be imported practically or when more current data is required, but its performance depends on the source.

18. What refresh options are available in Power BI?

Common refresh approaches include:

• On-demand refresh: A user manually refreshes an Import semantic model
• Scheduled refresh: Power BI refreshes an Import model at configured times
• Incremental refresh: Only recent or changed partitions are refreshed
• Automatic page refresh: A report page periodically sends new queries for supported DirectQuery scenarios
• Dashboard tile refresh: Cached dashboard tiles are updated after source or model changes

DirectQuery does not require a conventional data import refresh because the source is queried when users interact with the report. However, credentials, gateways, caches, and report pages may still require configuration.

19. What types of data sources can Power BI connect to?

Power BI can connect to:

• Files such as Excel, CSV, JSON, XML, PDF, and Parquet
• Databases such as SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, and SAP systems
• Azure services such as Azure SQL Database, Azure Synapse Analytics, and Azure Data Lake
• Online services such as SharePoint, Salesforce, Dynamics 365, and Google Analytics
• Power Platform sources such as Dataverse, dataflows, and Power BI semantic models
• Web pages, APIs, and OData feeds

The features available depend on the connector. Not every connector supports DirectQuery, folding, or the same authentication options.

20. What is a dashboard in Power BI?

A Power BI dashboard is a single-page canvas in the Power BI service. It contains tiles that can be pinned from one or more reports and, in some cases, different semantic models.

Dashboards are commonly used to present a concise monitoring view for executives or operational teams. Selecting a tile usually opens the report or content from which it originated.

Reports can contain multiple interactive pages, while dashboards remain single-page items in the Power BI service.

21. How are relationships defined in Power BI?

Relationships connect tables through matching columns. Important relationship properties include:

• Cardinality: One-to-many, many-to-one, one-to-one, or many-to-many
• Cross-filter direction: Single or both
• Active status: Active or inactive
• Related columns: The key columns used to connect the tables

Power BI can detect relationships automatically, but modelers should review the results. Incorrect relationships may produce duplicate totals, ambiguous filtering, or unexpected blank values.

22. What is the difference between an active and an inactive relationship?

An active relationship automatically propagates filters between related tables. An inactive relationship exists in the model but does not propagate filters unless a DAX calculation activates it.

For example, a Sales table may contain both OrderDate and ShipDate. The relationship between the Date table and OrderDate may be active, while the relationship to ShipDate is inactive.

A measure can use the inactive relationship with USERELATIONSHIP:

Orders Shipped =
CALCULATE(
   COUNTROWS(Sales),
   USERELATIONSHIP('Date'[Date], Sales[ShipDate])
)

Microsoft recommends using active relationships wherever practical. Inactive relationships are useful for role-playing dimensions, but RLS filters do not propagate through them.

23. Can a Power BI model contain a disconnected table?

Yes. A disconnected table has no physical relationship with the other model tables.

Common uses include:

• What-if parameters
• User-selected assumptions
• Dynamic metric selection
• Custom sort or display options
• Measure tables
• Scenario analysis

The selected value can be captured through functions such as SELECTEDVALUE and then used in a measure.

24. What does the CALCULATE function do in DAX?

CALCULATE evaluates an expression after modifying its filter context.

For example:

West Region Sales =
CALCULATE(
   SUM(Sales[SalesAmount]),
   Region[RegionName] = "West"
)

The first argument is the expression to evaluate. The remaining arguments add, replace, or remove filters.

CALCULATE can also perform context transition by converting an existing row context into filter context. This makes it one of the most important functions in DAX.

25. Where is data stored in Power BI?

The location depends on the storage mode.

• Import: Data is copied, compressed, and stored in the Power BI semantic model. In Power BI Desktop, the model is stored within the PBIX file.
• DirectQuery: The detailed data remains in the source. Power BI stores model metadata and sends queries to the source when needed.
• Composite: Some tables or partitions are imported while others use DirectQuery.
• Live connection: The report connects to an external semantic model or Analysis Services model.

Microsoft now uses the term semantic model for the content type previously called a Power BI dataset.

26. What is row-level security in Power BI?

Row-level security, or RLS, restricts which rows a user can see.

A company might use RLS so regional managers can view only the sales records for their own regions. Roles and filter expressions are normally created in Power BI Desktop and assigned to users or groups in the Power BI service.

Dynamic RLS can use functions such as USERPRINCIPALNAME() to identify the signed-in user and match that person to an access table.

27. Why are correct data types and formatting important in Power BI?

Correct data types affect calculations, relationships, sorting, storage, and visualization behavior.

For example:

• Dates should use a date or date-time type
• Numeric identifiers may need to be stored as text
• Currency and percentage fields should have appropriate formats
• Relationship columns should use compatible data types
• Unnecessary precision should be removed from numeric fields

Formatting changes how a value is displayed. It does not normally change the underlying value used by DAX.

28. What views are available in Power BI Desktop?

Power BI Desktop provides three main model and report views:

• Report view: Used to create report pages and visuals
• Table view: Used to inspect model data and create calculations
• Model view: Used to manage tables, relationships, properties, and model structure

The Power Query Editor is a separate interface that opens through Transform Data. Data cleaning and shaping should be performed there, not in Table view.

29. What is the difference between a semantic model, report, and dashboard?

A semantic model can support multiple reports. A dashboard can bring together tiles from different reports.

30. What is the difference between a star schema and a snowflake schema?

A star schema contains a central fact table connected directly to denormalized dimension tables.

A snowflake schema normalizes dimensions into additional related tables. For example, Product may connect to Subcategory, which then connects to Category.

A star schema generally makes the model easier to use and helps produce predictable filtering and DAX calculations.

Also Read: Star Schema vs Snowflake Schema

31. What is the difference between a calculated column and a measure?

Example calculated column:

Line Amount = Sales[Quantity] * Sales[UnitPrice]

Example measure:

Total Sales =
SUMX(
   Sales,
   Sales[Quantity] * Sales[UnitPrice]
)

Where possible, aggregations should normally be implemented as measures rather than stored calculated columns.

32. What is bidirectional cross-filtering?

Bidirectional cross-filtering allows filters to travel in both directions across a relationship.

It can solve specific modeling requirements, including some many-to-many scenarios. However, it should not be enabled by default. Excessive bidirectional filtering can create ambiguous paths, make calculations harder to understand, and reduce performance.

A well-designed star schema normally uses single-direction filtering from dimension tables to fact tables.

33. What are row context, filter context, and context transition?

Row context represents the current row being evaluated. Calculated columns and iterator functions such as SUMX commonly create it.

Filter context is the set of filters applied before a measure is evaluated. It can come from slicers, visual rows, page filters, report filters, relationships, or DAX.

Context transition occurs when CALCULATE converts an existing row context into filter context.

Understanding these concepts is essential because the same DAX expression can return different results under different contexts.

34. When should you use a custom visual?

A custom visual may be appropriate when built-in visuals cannot meet a specific reporting requirement.

Before adding one, verify:

• Whether the visual is certified
• Whether it meets accessibility standards
• Whether it affects report performance
• Whether data is sent to an external service
• Whether it is supported and maintained
• Whether users can interpret it correctly

A custom visual should solve a reporting problem, not simply make the report look different.

Enroll in the Data Analytics Certification Course to learn over 17+ data analysis tools and skills including, Tableau, Excel, SQL, Python, R, and PowerBI and gain real-world insights through live online classes led by industry experts.

35. What are fact and dimension tables?

A fact table stores measurable business events, such as sales transactions, website visits, invoices, or support tickets. It normally contains numeric values and foreign keys.

A dimension table describes the entities used to analyze those events, such as Date, Product, Customer, Employee, or Region.

For example:

• FactSales contains quantity, revenue, cost, product key, customer key, and date key
• DimProduct contains product name, brand, category, and subcategory
• DimDate contains date, month, quarter, and year

This separation forms the basis of a star schema.

36. What is the difference between COUNTROWS, COUNT, and DISTINCTCOUNT?

Examples:

Order Count = COUNTROWS(Sales)

Unique Customers =

DISTINCTCOUNT(Sales[CustomerID])

COUNTROWS is generally the clearest function when the requirement is to count records or rows. It can also count the rows returned by a filtered table expression.

37. What are common Power Query transformations?

Common Power Query transformations include:

• Changing data types
• Renaming or removing columns
• Filtering rows
• Replacing values
• Removing duplicates
• Splitting and combining columns
• Grouping data
• Pivoting and unpivoting
• Merging queries
• Appending queries
• Creating conditional and custom columns
• Filling values up or down
• Extracting data from dates, text, or structured columns

Power Query records these operations as Applied Steps and generates M code behind the interface.

38. What is the difference between merging and appending queries?

Merge combines columns from two queries based on one or more matching fields. It is similar to a SQL join.

Append adds the rows of one query below the rows of another query. It is similar to a SQL UNION ALL.

For example, joining Orders with Customers requires a merge. Combining January, February, and March sales files requires an append.

39. What is a responsive slicer?

A responsive slicer automatically adjusts its layout as its size changes.

For example, a horizontal slicer may reduce the number of visible items or switch to a more compact form when the report is displayed on a smaller screen. Responsive settings are useful when reports must work across desktop and mobile layouts.

40. What is query folding in Power Query?

Query folding occurs when Power Query translates transformation steps into a native query that the source system can execute.

For example, a row filter applied in Power Query may be converted into a SQL WHERE clause. This reduces the amount of data transferred to Power BI and can improve refresh and DirectQuery performance.

Query folding is especially important for DirectQuery and incremental refresh. Some transformations can break folding, so modelers should check whether later steps are still being executed at the source.

Advanced Power BI Interview Questions for Experienced Professionals

41. What is the difference between visual-level, page-level, and report-level filters?

• A visual-level filter affects only one visual
• A page-level filter affects applicable visuals on one report page
• A report-level filter affects applicable visuals throughout the report

The appropriate scope depends on the business requirement. A visual-level filter is useful for one chart, while a report-level filter is useful for a condition such as restricting the entire report to the current financial year.

42. What are common data-shaping techniques in Power BI?

Common techniques include:

• Filtering records at the source
• Removing unnecessary columns
• Correcting data types
• Splitting or combining columns
• Creating reusable staging queries
• Merging and appending data
• Unpivoting repeated month or category columns
• Grouping rows
• Creating reference queries
• Standardizing nulls and error values
• Preserving query folding
• Moving expensive transformations to the source

The objective is to create clean, analysis-ready fact and dimension tables rather than loading a single wide and inconsistent table.

43. How does scheduled refresh work?

Scheduled refresh reloads data for an Import semantic model at configured times in the Power BI service.

The model must have valid source credentials. A gateway is also required when the service cannot connect directly to the source, such as with many on-premises databases.

Shared capacity supports up to eight scheduled refreshes per day. PPU and Premium or Fabric capacity can support up to 48. DirectQuery models do not use scheduled model refresh in the same way because queries are sent to the source during report interaction.

44. What is an on-premises data gateway, and when is it required?

An on-premises data gateway provides a secure bridge between Microsoft cloud services and data sources that are not directly accessible from the cloud.

The main gateway options are:

• On-premises data gateway: Supports multiple users, data sources, and supported Microsoft cloud services
• On-premises data gateway in personal mode: Intended for one Power BI user and cannot be shared
• Virtual network data gateway: A Microsoft-managed option for sources secured within virtual networks

A gateway may be used for scheduled refresh, DirectQuery, or live connections to supported on-premises sources. Production environments generally use the standard gateway rather than personal mode.

45. Which in-memory engine does Power BI use?

Power BI Import models use the VertiPaq storage engine, which was also associated with the xVelocity name.

VertiPaq stores data in a compressed columnar format. Model size, column cardinality, data types, relationships, and the number of stored columns influence its performance.

Removing unused and high-cardinality columns can therefore reduce memory usage and improve model performance.

46. What is incremental refresh?

Incremental refresh divides a large table into date-based partitions and refreshes only the recent partitions that are expected to change.

The normal setup involves:

1. Creating RangeStart and RangeEnd parameters in Power Query
2. Filtering a date-time column using those parameters
3. Defining an incremental refresh policy
4. Publishing the model to the Power BI service
5. Running the initial refresh

Incremental refresh can significantly reduce refresh duration and source-system load for large historical tables.

47. What is a Composite model?

A Composite model combines multiple storage modes or data sources into a single semantic model.

For example, a model might:

• Import small dimension tables
• Keep a large transaction table in DirectQuery
• Use Dual mode for dimensions that must work efficiently with both imported and DirectQuery tables

Composite models attempt to combine the performance of Import with the scale or recency of DirectQuery. They require careful relationship, storage-mode, and source design.

48. What are the main stages of a Power BI project?

A typical Power BI project includes:

1. Requirement definition: Identify users, decisions, KPIs, grain, and security requirements
2. Data connection: Connect to the necessary sources
3. Data transformation: Clean and shape data in Power Query or the source platform
4. Data modeling: Build fact and dimension tables, relationships, hierarchies, and measures
5. Report design: Create visuals, navigation, interactions, and accessible layouts
6. Validation: Reconcile results with source systems and business definitions
7. Publishing: Publish content to a workspace
8. Security and distribution: Configure RLS, permissions, and apps
9. Refresh and monitoring: Manage gateways, schedules, usage, and performance

49. What is a Power BI workspace?

A workspace is a collaborative container in the Power BI service. It can contain reports, dashboards, semantic models, dataflows, notebooks, lakehouses, and other supported Fabric items.

The main workspace roles are:

• Admin
• Member
• Contributor
• Viewer

Permissions should be assigned according to what each user needs to create, edit, publish, manage, or consume. Finished content is often distributed to a wider audience through a Power BI app.

50. What is the Advanced Editor in Power Query?

The Advanced Editor displays the M code generated by Power Query.

It can be used to:

• Review the complete query
• Add or modify M expressions
• Create reusable functions
• Work with parameters
• Simplify repetitive transformation logic
• Debug transformation steps

Changes made in the Advanced Editor should be tested carefully because an incorrect expression can break subsequent Applied Steps.

51. How would you choose between Import and DirectQuery?

Use Import when:

• Fast report interaction is a priority
• The data can fit within the available model capacity
• Scheduled or incremental refresh meets the freshness requirement
• Full DAX and modeling flexibility is required

Consider DirectQuery when:

• The data is too large to import practically
• The source must remain the authoritative storage location
• Near real-time access is required
• Governance rules prevent data from being copied

DirectQuery should not be selected simply because the source contains many rows. Source performance, concurrency, query folding, network latency, model design, and user expectations must also be considered.

52. What is the difference between a dataflow and a semantic model?

A dataflow is primarily a reusable data-preparation layer. It uses Power Query to connect to, clean, and prepare data that multiple semantic models may then consume.

A semantic model adds analytical structure, including:

• Relationships
• Measures
• Hierarchies
• Formatting
• Security roles
• Business calculation logic

A dataflow prepares reusable tables. A semantic model organizes those tables for reporting and analysis.

53. How would you design a sales model using a star schema?

Begin with a fact table at a clearly defined grain, such as one row per sales transaction line.

The model might include:

• FactSales
• DimDate
• DimProduct
• DimCustomer
• DimStore
• DimSalesperson
• DimRegion

Each dimension would have a one-to-many relationship with the fact table. Filters would normally flow from the dimensions to FactSales.

Measures such as Total Sales, Gross Profit, Order Count, and Average Order Value would be created in DAX. Descriptive fields would remain in dimensions rather than being repeated in the fact table.

54. What are KPIs in Power BI?

A KPI is a measurable value used to evaluate performance against a target or business objective.

A useful KPI normally contains:

• An actual value
• A target or benchmark
• A time period
• A variance
• A status or trend indicator

Examples include revenue against target, customer retention rate, on-time delivery rate, gross margin, and average resolution time.

Candidates should explain how the KPI is defined and validated, not only how it is displayed.

55. What is a slicer?

A slicer is an interactive visual that allows users to filter report data.

Slicers can be used for fields such as date, region, product, department, or status. They can appear as lists, dropdowns, buttons, date ranges, or other supported styles.

Unlike filters hidden in the Filters pane, slicers are visible to report users and form part of the report experience.

Thinking about building a career in data analytics? This Data Analyst roadmap walks you through the learning path, tools, salary potential, and a complete career path needed to move forward with confidence.

56. A manager wants a report showing monthly sales trends with exceptions highlighted. How would you build it?

A suitable approach would be:

1. Create a proper Date table and relate it to the sales fact table
2. Create measures for Total Sales, Target Sales, and Variance
3. Use a line or column chart to show the monthly trend
4. Apply conditional formatting or a separate exception measure
5. Add slicers for year, region, and product
6. Add a tooltip or drillthrough page for transaction-level details
7. Validate totals against the source system
8. Test report performance and mobile usability

An exception measure might be:

Sales Status =
IF(
   [Total Sales] < [Sales Target],
   "Below Target",
   "On or Above Target"
)

57. How would you optimize a Power BI report that loads slowly?

Start by identifying the bottleneck rather than changing the report mindlessly. Power BI Performance Analyzer can show the time spent on DAX queries, visual rendering, and other operations.

Possible improvements include:

• Removing unused rows and columns
• Reducing high-cardinality fields
• Using a star schema
• Preferring Import when appropriate
• Preserving query folding
• Moving heavy transformations to the source
• Replacing unnecessary calculated columns with measures
• Simplifying expensive DAX expressions
• Using variables to avoid repeated calculations
• Reducing the number of visuals on each page
• Limiting unnecessary interactions
• Using aggregation tables
• Configuring incremental refresh
• Optimizing the source database for DirectQuery
• Testing custom visuals separately

Performance should be evaluated at the source, Power Query, semantic model, DAX, visual, capacity, and network levels.

58. How should you prepare for a Power BI interview?

Preparation should include both conceptual revision and hands-on work.

Focus on:

• Data modeling and star schemas
• Relationships and cardinality
• Calculated columns and measures
• Filter context and row context
• Common DAX functions
• Power Query transformations
• Import, DirectQuery, and Composite models
• Gateways and refresh
• RLS
• Report optimization
• Power BI service concepts

Build at least one complete project and practice explaining the business requirement, data model, transformations, DAX logic, design choices, validation process, and outcome.

59. How can you stand out in a Power BI interview?

Use a real project to demonstrate how you make decisions.

Explain:

• Why you chose a particular data model
• How you handled data-quality problems
• Why a calculation was created as a measure rather than a column
• How you validated the results
• How you improved report performance
• How users interacted with the report
• What business decision the report supported
• What you would improve in the next version

A well-explained project is usually more valuable than showing a visually impressive dashboard without discussing the underlying model.

60. What soft skills are important for Power BI professionals?

Important soft skills include:

• Translating business questions into analytical requirements
• Communicating with technical and nontechnical stakeholders
• Explaining assumptions and limitations
• Asking precise follow-up questions
• Validating definitions with subject-matter experts
• Presenting insights clearly
• Managing conflicting reporting requirements
• Documenting data sources and calculations
• Collaborating with data engineers, analysts, and business teams

Power BI work is not limited to creating charts. It requires understanding what decision the user needs to make and ensuring the data can support that decision.

Watch the video below for a quick walkthrough of the most commonly asked Power BI interview questions, key concepts, and practical tips.

Conclusion

Preparing for Power BI interview questions requires more than memorizing definitions. Interviewers often expect candidates to explain how they would clean data, build relationships, write DAX measures, choose between Import and DirectQuery, secure reports, and improve performance. Practicing with real datasets and complete reporting projects can help you answer these questions with greater clarity and confidence.

Simplilearn’s Power BI Certification Training Course can help you strengthen your skills in DAX, data modeling, dashboards, and report optimization. For a broader learning path, the Data Analyst Certification Course covers Power BI alongside SQL, Excel, Python, Tableau, and other core data analysis skills.

Key Takeaways

• The Power BI interview questions focus on the practical knowledge of data, models, calculations, reports, and business requirements.
• Freshers should be able to describe the following: Power BI Desktop, Power Query, DAX, Reports, Dashboards, filters, and relationships.
• Intermediate candidates should be familiar with the concepts of star schemas, measures, calculated columns, filter context, query folding, and storage modes.
• Experienced candidates should be prepared to talk about gateways, incremental refresh, Composite models, security, governance, and performance optimizations.
• Good candidates structure their answer with examples drawn from either reports or projects they have developed.