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,

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi SANKETPATIL ,

    Glad to hear your query has been resolved! If the response provided by DataNinja777  addressed your issue, please mark it as Accepted Answer and click Yes if you found it helpful. This will help other community members with similar questions find a solution more quickly.

    Should you have any further questions, feel free to reach out.
    Thank you for being a part of the Microsoft Fabric Community Forum!