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

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

Fair question on requirements, but I'm really making this up as I go. We're still getting data cleansed & standardized in an Azure SQL Data Warehouse, so I'm trying to evaluate options on BI & Reporting tools in parallel as time allows...which means that there was no requirement for matrices of data. It was just what I was doing that day while exploring options for self-service BI that might mimic what we could get from ROLAP tools like MicroStrategy or Cognos.

greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident 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
    Icon for Advocate I rankAdvocate 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.