Einzigartige - Web & App Development Company
📊 Power BI Interview Questions & Answers (Intermediate Level 22–50) #14
Unanswered
hirenpatel1903
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
📊 Power BI Interview Questions & Answers (Intermediate Level 22–50)
A structured and interview-focused collection of Power BI Intermediate Level Questions & Answers designed for:
This section covers Data Modeling, DAX, RLS, Service, Refresh, and Performance concepts.
📌 Why This Repository?
✔ Interview-focused answers
✔ Clear and practical explanations
✔ Covers real-world scenarios
✔ Beginner → Intermediate → Advanced structure
✔ SEO-optimized for GitHub discoverability
🟡 Intermediate Level (22–50)
22️⃣ What is Star Schema?
Star Schema is a data modeling technique where:
Benefits:
23️⃣ What is Snowflake Schema?
Snowflake Schema is an extension of Star Schema where:
Pros:
Cons:
24️⃣ What is Cardinality in Relationships?
Cardinality defines how tables relate:
Most common in Power BI: One-to-Many
25️⃣ What is Cross-Filter Direction?
Defines how filters flow between tables:
Use bi-directional carefully to avoid ambiguity.
26️⃣ Difference Between Import & DirectQuery?
27️⃣ What is Composite Model?
Composite model allows combining:
In the same Power BI model.
28️⃣ What is Row-Level Security (RLS)?
RLS restricts data visibility for users.
Example:
29️⃣ How Do You Implement RLS?
Steps:
30️⃣ What is a Hierarchy in Power BI?
Hierarchy is a structured drill-down path.
Example:
Year → Quarter → Month → Day
Improves navigation and reporting.
31️⃣ What is KPI Visual?
KPI visual displays:
Used for performance tracking.
32️⃣ What is Conditional Formatting?
Changes visual appearance based on rules.
Example:
33️⃣ What is Data Refresh?
Data refresh updates dataset with latest source data.
Types:
34️⃣ What is Scheduled Refresh?
Automatic refresh at defined intervals in Power BI Service.
Requires:
35️⃣ What is Incremental Refresh?
Refreshes only new or changed data instead of full dataset.
Improves:
36️⃣ What is Power BI Gateway?
Gateway connects:
On-Premise Data → Power BI Service
Types:
37️⃣ What is Power BI Service?
Cloud platform for:
38️⃣ What is Power BI Report Server?
On-premises server to host Power BI reports without cloud dependency.
39️⃣ What Are Workspace Roles?
40️⃣ What is a Dataset in Power BI?
Dataset is the published data model containing:
41️⃣ What is Data Modeling?
Data modeling is the process of:
42️⃣ What is Context in DAX?
Context determines how DAX calculations behave.
Types:
43️⃣ What is Filter Context?
Filter context is created by:
Measures react dynamically to filter context.
44️⃣ What is Row Context?
Row context applies to:
It evaluates one row at a time.
45️⃣ Difference Between SUM and SUMX?
Example:
SUM(Sales[Amount])
SUMX(Sales, Sales[Qty] * Sales[Price])
46️⃣ What is CALCULATE Function?
CALCULATE modifies filter context.
Example:
CALCULATE(SUM(Sales[Amount]), Region = "East")
Most powerful DAX function.
47️⃣ What is RELATED Function?
RELATED retrieves value from related table.
Used in calculated columns.
48️⃣ What is ALL Function?
ALL removes filters from a table or column.
Used for:
49️⃣ What is Time Intelligence in DAX?
Time-based calculations such as:
Requires proper Date Table.
50️⃣ What is YTD Calculation?
Year-To-Date (YTD) calculates cumulative value from start of year to current date.
Example:
TOTALYTD(SUM(Sales[Amount]), Date[Date])
🎯 What You Should Master at Intermediate Level
🚀 Coming Next
⭐ If You Found This Helpful
🌐 Follow & Subscribe
📊 Live YouTube Statistics
👉 Subscribe here: https://www.youtube.com/@einzigartige_/
Beta Was this translation helpful? Give feedback.
All reactions