Forum Discussion

fchukoskie's avatar
fchukoskie
Advocate 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

greggyb's avatar
greggyb
Resident Rockstar
10 years ago

fchukoskie, understood. Hopefully my explanations helped you understand the behavior better. I would recommend playing with Power BI some more with this new understanding. The relationship semantics are a bit unfamiliar at first, but it turns out they encourage design patterns that end up making the reporting and analysis pieces very intuitive even for non-technical end users.

 

Ultimately, Power BI is a very flexible suite of tools that deserves attention, even if it's not the solution you choose.

fchukoskie's avatar
fchukoskie
Advocate I
10 years ago

greggyb It made perfect sense, thanks. Long-term, it's looking like a good fit for the times when I want something like QlikView, but less so for the times when I need MicroStrategy/Cognos ROLAP like behavior.