Hello.
I’ve used the API to connect my forms to Power BI. I have studied the JSON response and I understand that Power BI flattens the hierarchy. I’m currently looking at my options when it comes to transforming this data.
We send our forms to our students. These forms have a first multiple choice question that asks the user what master did they complete. The rest of the answers are in relation to that master (numeric values).
My question is, is there some way I could separate this first question (master) from the others, and then group the rest of the questions and link them to the question? So, going from:
“student → question → answer, student → question → answer...”
to
“first answer → rest of the answers by that student”
I know changing the form could solve that issue, but first I want to know if there is some way to do this with JSON formatting or data transformation.
Thank you!