Power BI
Export PDF (0)
Flagged
Completed
Export PDF (0)
0%
Foundational
What are the main components of the Power BI ecosystem?
Junior
What is the difference between a Calculated Column and a Measure in DAX?
Junior
What is Power Query, and what role does it play in Power BI?
Junior
What is the difference between a Report and a Dashboard in Power BI?
Junior
How do you manage relationships between tables in Power BI?
Junior
Architecture & Administration
What is the On-premises Data Gateway, and what is the difference between Standard and Personal mode?
Mid
Compare Power BI Pro, Premium Capacity, and Premium Per User (PPU).
Mid
What are Power BI Dataflows, and when should a lead architect recommend them?
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
Explain the concept of Deployment Pipelines in Power BI.
Senior
Data Modeling
Why is a Star Schema strongly preferred over a single flat table in Power BI?
Mid
What is the difference between an active and an inactive relationship?
Mid
Explain the different Storage Modes 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 does the
CALCULATE
function do?
Mid
What is the difference between
SUM
and
SUMX
?
Mid
What are the strict requirements for a DAX Time Intelligence Date table?
Mid
What is the difference between
VALUES
and
DISTINCT
?
Mid
Explain Filter Context vs. Row Context.
Senior
Explain Context Transition in DAX.
Senior
How do
ALL
,
ALLEXCEPT
, and
ALLSELECTED
differ?
Senior
Explain the
EARLIER
function and its modern alternative.
Senior
How would you optimize a slow-performing DAX measure?
Senior
Performance Optimization & Troubleshooting
How do you utilize the Performance Analyzer in Power BI Desktop?
Senior
What is the VertiPaq engine, and how does it compress data?
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
Explain the 'Auto Date/Time' feature and why architects usually disable it.
Senior
Power Query & M Language
What is the M language, and how does it fundamentally differ from DAX?
Mid
What is Query Folding, and why is it critical for enterprise performance?
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
Explain the purpose of
Table.Buffer
in M.
Senior