Forum Discussion

VipinReddy's avatar
VipinReddy
Microsoft Employee
4 years ago

Import and Direct query working differently.

Hi All, 

 

I have two tables which are shown below. 

Table1 

ID NameArea Amount
1Name1India100
2Name2USA100
3Name3Canada200

Table 2 

ID Review 
1TRUE
2FALSE

 

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 
USA1100
Canada1200

 

Case2 - Table 2 Direct Query mode. 

Area Count of ID's Amount 
USA1100

 

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

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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