Forum Discussion

netea's avatar
netea
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...
Need Help
netea's avatar
netea
New Member
5 years ago
I checked the data and the data model, everything's fine.
manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution 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's avatar
    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's avatar
      v-lili6-msft
      Icon for Community Support rankCommunity 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