title: Convert SQL to Power BI
body: <p>I'm very new to Power BI, therefore please be indulgent with me :D</p>
  <p>Actually, I have 2 tables called Report and Mails. In the Report table I have a column Racine and in the Mails table I have a column called Body that might contain Racine.</p>
  <p>I would like to convert this sql to Power BI</p>
  <pre><code>select Report.Racine, Mails.Body 
  from Report, Mails
  where Mails.Body LIKE '%' + Report.UserId + '%'; 
  </code></pre>
  <p>Example:</p>
  <p>Table Report</p>
  <pre><code>Racine
  1234
  5678
  9012
  0987
  </code></pre>
  <p>Table Mails</p>
  <pre><code>Body
  'abc 1234 AZER'
  'PO5678 tgcv'
  'YF1234GHQ'
  </code></pre>
  <p>The result should be</p>
  <pre><code>Racine             Body
  1234               'abc 1234 AZER'
  1234               'YF1234GHQ'
  5678               'PO5678 tgcv'
  9012               *null*
  0987               *null*
  </code></pre>
  <p>Is it possible?</p>
  <p>Thx in advance.</p>