I think you will need to create a separate Sharepoint List or Excel Table with the correct answers of each question (This should have only one record with many columns of question answers). Read that into Power BI, then using the Query Edit to merge the answer table to the quiz responses table, and compare each response column to the correct answer column. Create a new column for Right/Wrong for each question, If Response=Correct Answer, then Right (1), else Wrong (0). Then sum the wright/wrong scores to get the total score column. Then you can create a chart showing the scores for each student.
Great tips!! but do you have any suggestion, If I would like to correct point score from quiz in sharepoint list?
Matthew a question: what connectors we can use to extract data from teams to power BI?
How do I automatically record or report the quiz score/results in Sharepoint and in PowerBI? (not the quiz response). Please help.
I looking for this for a week too.
I think you will need to create a separate Sharepoint List or Excel Table with the correct answers of each question (This should have only one record with many columns of question answers). Read that into Power BI, then using the Query Edit to merge the answer table to the quiz responses table, and compare each response column to the correct answer column. Create a new column for Right/Wrong for each question, If Response=Correct Answer, then Right (1), else Wrong (0). Then sum the wright/wrong scores to get the total score column. Then you can create a chart showing the scores for each student.
@@gabrielferreiraguimaraes2092 See below. Hope it helps.