title: Power pivot relation between tables from data model created with power Query
body: <p>I made a relation 1 to many between to table but when I try to use it in a pivot table it fails. I get the usual yellow message saying it may lack a relation. When I let it try to detect one it fails to find anything possible and when I check the existing ones, mine is there and done properly.</p>
  <p>Here is a mock-up of the situation :</p>
  <p>These are the simple tables :
  <a href="https://i.stack.imgur.com/iBzS2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iBzS2.png" alt="enter image description here" /></a></p>
  <p>To send the values to the data model I make those tables go through Power Query because the real situation requires Power Query. No additional steps are added, it's just the &quot;From table or range&quot; source.</p>
  <p>Then, in Power Pivot, I create the relation with the diagram view :
  <a href="https://i.stack.imgur.com/evYtu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/evYtu.png" alt="enter image description here" /></a></p>
  <p>When I then create a pivot table, the relation has not impact :
  <a href="https://i.stack.imgur.com/eJjSB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eJjSB.png" alt="enter image description here" /></a></p>
  <p>I also tried to add a measure and use it at as the value but to no avail :</p>
  <pre><code>Price:=SUMX(Rqt_Ref;Rqt_Ref[C_B]*Rqt_Ref[C_C])
  </code></pre>
  <p>I did not create the pivot table with the original tables instead of the one that were send to the date model because I want this to work even if there are more than 1 048 576 rows.</p>
  <p>I have no idea as for why it fails and I welcome any comment.</p>
  <p>Edit : Since I don't want to do the job in Power Pivot with DAX (related) I did the merge with Power Query <code>Merge queries</code> :
  <a href="https://i.stack.imgur.com/yQET0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yQET0.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/lMkdv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lMkdv.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/BsU8R.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BsU8R.png" alt="enter image description here" /></a></p>