Power BI
Export PDF (0)
Flagged
Completed
Export PDF (0)
0%
Foundational
How do you manage relationships between tables in Power BI?
Junior
What are the main components of the Power BI ecosystem?
Junior
What is Power Query, and what role does it play in Power BI?
Junior
What is the difference between a Calculated Column and a Measure in DAX?
Junior
What is the difference between a Report and a Dashboard in Power BI?
Junior
Architecture & Administration
Compare Power BI Pro, Premium Capacity, and Premium Per User (PPU).
Mid
What is the On-premises Data Gateway, and what is the difference between Standard and Personal mode?
Mid
Explain the concept of Deployment Pipelines in Power BI.
Senior
Explain the difference between Row-Level Security (RLS) and Object-Level Security (OLS).
Senior
How does Incremental Refresh work in Power BI, and what are the prerequisites?
Senior
What are Power BI Dataflows, and when should a lead architect recommend them?
Senior
Data Modeling
Explain the different Storage Modes in Power BI.
Mid
What is the difference between an active and an inactive relationship?
Mid
Why is a Star Schema strongly preferred over a single flat table in Power BI?
Mid
Explain bi-directional cross-filtering and its potential pitfalls.
Senior
What are Aggregation tables, and how do they improve performance?
Senior
Dax
What are the strict requirements for a DAX Time Intelligence Date table?
Mid
What does the
CALCULATE
function do?
Mid
What is the difference between
SUM
and
SUMX
?
Mid
What is the difference between
VALUES
and
DISTINCT
?
Mid
Explain Context Transition in DAX.
Senior
Explain Filter Context vs. Row Context.
Senior
Explain the
EARLIER
function and its modern alternative.
Senior
How do
ALL
,
ALLEXCEPT
, and
ALLSELECTED
differ?
Senior
How would you optimize a slow-performing DAX measure?
Senior
Power Query & M Language
What is the M language, and how does it fundamentally differ from DAX?
Mid
Explain the purpose of
Table.Buffer
in M.
Senior
How can you tell if Query Folding is breaking, and how do you prevent it?
Senior
How do you handle dynamic data sources or changing column names in Power Query?
Senior
What is Query Folding, and why is it critical for enterprise performance?
Senior
Performance Optimization & Troubleshooting
Explain the 'Auto Date/Time' feature and why architects usually disable it.
Senior
How do you utilize the Performance Analyzer in Power BI Desktop?
Senior
How would you drastically reduce the size of a bloated Power BI dataset?
Senior
What is DAX Studio, and how do leads use it?
Senior
What is the VertiPaq engine, and how does it compress data?
Senior