Forum Discussion

db042190's avatar
db042190
Icon for Impactful Individual rankImpactful Individual
7 years ago

tabular import doesnt see existing tabular relationship

Hi I connected from desktop to my tabular cube and requested import.  My fact table is just stock values like open , close, volume etc.  It has a foreign key to DimCompany.  DimCompany basically has company name and stock symbol.

 

When I choose both tables in navigator, my preview shows all permutations, not just related items.  Below are each of the tables selected individuall, and then both.  Following that is the relationship as its defined in vs ssdt.

 

Is this how desktop is supposed to work?  am i forced to issue a dax query to overcome this.  I dont want live query at the moment.

 

 

 

 

 

 

Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi db042190 ,

    When you import data from SSAS cube to Power BI Desktop, it will only import objects(like dimensions, measures) with data in SSAS database, it will not import the relationship.

    Best Regards,

    Teige

    • db042190's avatar
      db042190
      Icon for Impactful Individual rankImpactful Individual
      7 years ago

      thx Teige.  I dove a little deeper after Teo's company weighed in.

       

      What you said appears to be true if you have no calculated measures (as was my case) or havent selected calculated measures (which i tried both ways later). 

       

      Once you've selected a calc'd measure, pbi's import flavor of ssas tabular "sees" the relationship.  That's pretty bizzarre to me especially since a live connection sees the relationship even in a cube with no calc'd measures. 

       

      If this ever comes up in real life for me, I'll be sure to introduce a DAX natural inner join to teach pbi what it should have already known.