Forum Discussion

fchukoskie's avatar
fchukoskie
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Star Schema cross-join

I'm creating my first PowerBI dashboard, using DirectQuery against an Azure SQL Data Warehouse instance, and am seeing strange cross-joins.   When I add 1 fact table and 2 dimensions to the model a...
  • andre's avatar
    andre
    10 years ago

    i don't think bidirectional will work with direct query mode

andre's avatar
andre
Icon for Memorable Member rankMemorable Member
10 years ago

Well, direct query mode has intrinsic technical challenges since the data do not live in the model.  I will gladly trade directional relationships for ability to enhance direct query mode based models with calculations.