Forum Discussion

SANKETPATIL's avatar
SANKETPATIL
New Member
1 year ago
Solved

Data Modelling

Summary: I am working survey data report & getting many to many relationship   Data Details: 300 respondents (who given responses #panel) 30 questions. (This were recorded in pivot form e.g...
Need Help
  • DataNinja777's avatar
    DataNinja777
    1 year ago

    Hi SANKETPATIL ,

     

    The problem here lies in the fact that you have kept questions tables separate in your data model.  In your case, the best method is to simply append all question tables into one combined table in Power Query, as long as each table already has one row per respondent per option. Just add a column to identify the question number before appending. This structure avoids many-to-many issues and allows proper relationships for interactive reporting.

     

    Best regards,

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
1 year ago

Hi SANKETPATIL ,

 

The problem here lies in the fact that you have kept questions tables separate in your data model.  In your case, the best method is to simply append all question tables into one combined table in Power Query, as long as each table already has one row per respondent per option. Just add a column to identify the question number before appending. This structure avoids many-to-many issues and allows proper relationships for interactive reporting.

 

Best regards,