tabular import doesnt see existing tabular relationship

[db042190]

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.

[TeigeGao]

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]

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.