Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
RyanGilreath
Regular Visitor

Customer Voice - Matrix Question relating back to Parent question

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!

2 REPLIES 2
nguyengiang2004
Frequent Visitor

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
New Member

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.

LukeGoble_0-1677034449326.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.