Forum Discussion

New Member

5 years ago

Join direct query and imported data - stopped working recently

Hi, I have a dashboard with the data model where I join a direct query table with the imported data table on one column with the same values. It used to work pretty well, I was able to display da...

Icon for Solution Sage rank

Solution Sage

5 years ago

Did you check the data on the model if it is proper or not?

I don't think it is due to the join. Please check if something has broken or also check if any report level filters applied.

And check if there is filter step applied unexpectedly.

regards,

Manikumar

New Member

5 years ago

I checked the data and the data model, everything's fine.

manikumar34
Solution Sage
5 years ago
netea , It's difficult to say then where it is breaking.

Please check with the filters. And try placing the columns on a tbale visual to check the data.

Regards,
manikumar
- netea
  New Member
  5 years ago
  I checked all data without any filters and as I said: data is fine, no reason for it not to work. it used to work and it stopped recently without any changes from my side (and anyone else as I have my local version and this one also stopped working)
  I really think there was a change to the way power bi process the direct query data.
  
  Any thoughts?
  - v-lili6-msft
    Community Support
    5 years ago
    hi netea
    
    I have tested on my side, it works well
    
    do you mean when you put data from import table and directquery table into one visual, then it will show blank?
    
    i think this should be something wrong with the fileds that you used to join the two tables.
    
    for example:
    
    "A" and "A ", the two row won't match beacuse there is blank in "A ", so they are not same.
    
    Regards,
    
    Lin