Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

PowerBI Many to Many relationships on Multidimensional

Hello Guys, Quick question, if I make a MultiDimensional Model on Visual Studio which later is fed to an Analysis Services Server on a SQL Database 2016 and use Directquery on PowerBI to connect t...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,

     

    >>Another thing if I develop the model on SSAS Multidimensional, my measures will have to be written in MDX, correct? 

    Current many to many relationship not works in power bi, you should rebuild these relationship by many to one relationship.(maybe you need to use temporary table to achieve this)

    For your measures who written based on M:M relationship, they not available in power bi desktop.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

>>Another thing if I develop the model on SSAS Multidimensional, my measures will have to be written in MDX, correct? 

Current many to many relationship not works in power bi, you should rebuild these relationship by many to one relationship.(maybe you need to use temporary table to achieve this)

For your measures who written based on M:M relationship, they not available in power bi desktop.

 

Regards,

Xiaoxin Sheng