Power BI Designer - Lookup Table Relationships

All replies

• 

  

  1

  Sign in to vote

  HI Snowball92,

  You should be able to do this...

  

  Can you double check that each of your fact -> dimension relationships are set up similar to this...

   

  If the relationships were auto-detected you can alter them to have a similar setup to that shown in the above screenshot.

  ---

  Regards,
  
  Michael Amadi
  
  Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)
  
  Website: http://www.nimblelearn.com, Twitter: @nimblelearn
  

  • Edited by Michael AmadiModerator Monday, June 8, 2015 4:52 PM
  • Marked as answer by Ed Price - MSFTMicrosoft employee Sunday, July 10, 2016 5:56 AM

  Monday, June 8, 2015 4:50 PM

  Moderator
• 

  

  1

  Sign in to vote

  Hi Michael,

  Many thanks for the response. I tried the above, and it seems that it only works once, (linking fact tables to one dimension table). If I then want to link 3 fact tables to a DIFFERENT dimension table, it will not work:

  The first relationship (Week Periods > Fact tables) is set up correctly.

  I then do the same for Resources > Fact Tables and only 1 can be active.

  Is this a defect or am i doing something wrong here? This happens for any combination of tables, not just the above example.

  I tried inserting screenshots but it says i am unable to until my account is verified.

  Thanks,

  James

  Monday, June 8, 2015 5:40 PM
• 

  

  1

  Sign in to vote

  Hi James,

  Since your account is yet to be verified, could you try uploading a screenshot to a public location using something like OneDrive or Dropbox.

  I've been able to successfully create a relationship between Sale -> Category and then a second one with Sale -> Date in the example I've tested with...

  

  

  ---

  Regards,
  
  Michael Amadi
  
  Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)
  
  Website: http://www.nimblelearn.com, Twitter: @nimblelearn
  

  • Edited by Michael AmadiModerator Monday, June 8, 2015 11:15 PM
  • Marked as answer by Ed Price - MSFTMicrosoft employee Sunday, July 10, 2016 5:56 AM

  Monday, June 8, 2015 10:31 PM

  Moderator
• 

  

  1

  Sign in to vote

  Thanks Michael.

  I got this far - could you then try and create another relationship between a different fact table (Stock or Investment) and the Date table?

  So you would end up with 2 active relationships to the date tables also.

  This is where the problem occurs as far as I can see.

  Tuesday, June 9, 2015 8:57 AM
• 

  

  1

  Sign in to vote

  Ah, I've seen your issue. At first glance it looks like the Power BI Designer Preview isn't matching the behaviour of Power Pivot. Upon closer inspection, it's because the Power BI Designer has support for bi-directional relationships and Power Pivot doesn't. It's the behaviour of the bi-directional relationships (i.e. Cross filter direction set to 'Both') that is causing the issue.

  

  To get the same behaviour in the Power BI Designer as with Power Pivot, you need to make sure that all your relationships have their Cross filter direction property set to 'Single'. After doing this, you will be able to set the relationship to active and get the behaviour you're after.

  

  ---

  Regards,
  
  Michael Amadi
  
  Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)
  
  Website: http://www.nimblelearn.com, Twitter: @nimblelearn

  • Edited by Michael AmadiModerator Tuesday, June 9, 2015 2:25 PM Minor edit
  • Marked as answer by Ed Price - MSFTMicrosoft employee Sunday, July 10, 2016 5:56 AM

  Tuesday, June 9, 2015 9:29 AM

  Moderator
• 

  

  1

  Sign in to vote

  Thanks Michael - this is working now! I had a couple of relationships that were set as "Both".

  Cheers,

  James

  Tuesday, June 9, 2015 10:47 AM