Asked In Service Based Company
POWER BI INTERVIEW QUESTIONS
Note:- Asked In @Deloitte
@PREMMANDAL CLEAN AND SHORT PDF FOR
YOU
BUSINESS & DATA ANALYST
EASY TO LEARN
Question 1
What Will Happen If Many To Many Relationship Exist Between 2 Tables In
Power BI In Data Modeling
Answer:-
Filtering and Slicing Issues: Filtering and slicing data may not behave as
expected due to the potential for multiple matches. This can lead to unexpected
results when visualizing data or creating measures.
Cross Filtering: In Power BI, relationships automatically enable cross-filtering
between tables. With many-to-many relationships, cross-filtering can become
more complex and may not provide the desired outcomes.
Ambiguity in Aggregations: Aggregations (such as sum, average, etc.) can
become ambiguous when there are multiple related records. Power BI may not be
able to determine which records to aggregate.
Performance Impact: Many-to-many relationships can have a performance
impact, particularly with large datasets, as Power BI has to navigate through
potentially complex relationships to fetch the data.
DAX Measures and Calculations: When working with many-to-many
relationships, you may need to create more complex DAX measures and
calculations to handle the ambiguity and provide accurate results.
Question 2
There are 2 slicers and 5 visuals in a Page, when I click on 1st slicers other
visuals are filtering and for the 2nd slicers they are not filtering. Why?
Answer:-
We have some possible reasons:-
1. Relationships in the Data Model:
Ensure that there is a valid relationship between the field used in the second slicer and
the fields in the visuals you expect to be filtered. In Power BI, relationships between
tables play a crucial role in filtering data across different visuals.
2. Slicer Configuration:
Check the configuration of the second slicer to make sure it is set up correctly. Ensure
that the slicer is bound to the appropriate field and that the field in the slicer is part of
the relationship established in the data model.
3. Cross-Filter Direction:
Verify the cross-filter direction on the relationship between the tables. Depending on
the nature of your data, you may need to set the cross-filter direction to "Both" or
"Single" to control how filtering occurs between tables.
4. Filters in Visual Interactions:
Inspect the visual interactions settings for each visual on the page. Click on a visual, go
to the Format pane, and check the "Edit interactions" option. Ensure that the second
slicer is set to affect the visuals you want it to influence. Incorrect settings here can
lead to visuals not responding to slicer interactions.
5. Data Cardinality:
Consider the cardinality of the relationship between the tables. If there is a many-to-
many relationship, it might require additional considerations or adjustments. Ensure
that the data model's cardinality is appropriate for the type of relationship you want to
establish.
Question 3
How you Handle MANY TO MANY Relationship In Power BI
Answer:-
In Power BI, resolving a many-to-many relationship typically involves creating a
bridge table, also known as a junction table or a link table. This bridge table helps
break down the many-to-many relationship into two one-to-many relationships,
making it easier for Power BI to handle.
Here are the general steps to resolve a many-to-many relationship in Power BI:
1. Identify the Tables Involved: Identify the two tables with the many-to-many
relationship. Let's call them Table A and Table B.
2. Create a Bridge Table: Create a new table, often referred to as a bridge table,
that contains unique combinations of keys from both Table A and Table B. This
table acts as a bridge between the two tables.
Question 4
Suppose we have a report called Report 1, which we published in Workspace 1.
Report 1 has two visualizations: Visualization 1 and Visualization 2. Similarly,
suppose we have a report called Report 2, which we published in Workspace 2.
Report 2 also has two visualizations: Visualization 1 and Visualization 2. Now, we
have clicked on the pin icon of Visualization 1 from Report 1, which is available in
Workspace 1, and created Dashboard 1 by adding Visualization 1 from Report 1 to
it. Can we now pin Visualization 1 from Report 2, which is available in Workspace 2,
into Dashboard 1?
Answer:-
So, the answer to this question is No, we can't pin Visualization 1 of Report 2, which
is available in Workspace 2, into Dashboard 1.
Why? Because if we publish Report 1 into Workspace 1, its scope is limited to
Workspace 1. This means we can pin the visualization from Report 1 into Dashboard
1 because Dashboard 1 is within Workspace 1. Therefore, we can pin Visualization 1
of Report 1 only into Dashboard 1.
Similarly, if we publish Report 2 into Workspace 2, its scope is limited to Workspace
2. This means we can pin the visualization from Report 2 into Dashboard 2, which is
created within Workspace 2. Therefore, we can pin Visualization 1 of Report 2 only
into Dashboard 2.
That's why we can't pin Visualization 1 of Report 2 into Dashboard 1, because
Dashboard 1 is in Workspace 1, and Visualization 1 of Report 2 is in Workspace 2.
@PREMMANDAL
BUSINESS & DATA ANALYST
Was this helpful
WOULD YOU MIND SHOWING YOUR SUPPORT
BY GIVING IT A LIKE?
INSPIRE ME TO CREATE MORE!
