Customer Voice - Matrix Question relating back to Parent question

[RyanGilreath]

Hello,

I've successfully linked my Customer Voice survey responses to PowerBI and have had a generally easy time of displaying simple "Ranking" style questions, as well as NPS and Choice.

The Matrix Choice questions however, have me stumped.

Where I am at right now is that there are two IDs in the "msfp_question" entity, 1 for the Parent Question and 1 for the Matrix options. What is the best way to relate these two so that I can display a table or matrix where the rows represent the individual respondents and the columns represent the Matrix question (parent and child). I have two of these in a survey and i'd like to use one visualization to represent them both.

Thanks in advance for any help!

[Anonymous]

You can use msfp_sourceparentquestionidentifier from MatrixChoice row (child) to link with msfp_sourcequestionidentifier from MatrixChoiceGroup (parent) to connect child with parent question. They are both from msfp_question entity.

[LukeGoble]

I'm having a similar issue. I have related the appropriate tables in Power BI, but for matrix type questions, the "Questiontext" values are null, making it impossible to pivot by question text.