Import and Direct query working differently.

[VipinReddy]

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

[v-kkf-msft]

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

[amitchandak]

@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