Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have two tables which are shown below.
Table1
ID | Name | Area | Amount |
1 | Name1 | India | 100 |
2 | Name2 | USA | 100 |
3 | Name3 | Canada | 200 |
Table 2
ID | Review |
1 | TRUE |
2 | FALSE |
I have created a visual in PowerBI which shows the count of IDs and amount based on area and I am applying the review filter on it as not true, which means I only want to see the records that are not reviewed.
Case1 - Table 2 Import Mode
This is of my visual looks.
Area | Count of ID's | Amount |
USA | 1 | 100 |
Canada | 1 | 200 |
Case2 - Table 2 Direct Query mode.
Area | Count of ID's | Amount |
USA | 1 | 100 |
The relationship between table1 and table2 is the same in both cases. Why is the visual not showing Canada's record in direct query mode? What is the difference between Import and direct query in this situation? Will I be able to show Canada's record using direct query mode?
I am attaching original PowerBI screenshots below.
Import Mode -
Direct Query Mode
Hi @VipinReddy ,
What is the version of Desktop you are using?
How to create your inter-table relationships?
Is the filtering done in the slicer or in the filter pane? If in the filter pane, are you using the following advanced filtering?
Best Regards,
Winniz
@VipinReddy , That is strange. Ideally, there should not be any different.
Please check if something getting added to power query (in open data transformation)
Also run a group by query on database and check is there any issue there
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |