Power BI: How to Auto Load Microsoft Forms Result Data -- Part 2: Advanced with Power Automate

Part 2 of the video use Power Automate to import the Quiz and Personal Form data.
For easiest way to import data into Power BI, please check Part 1: Basic • Power BI: How to Auto ...
Power Automate: us.flow.micros...
Record form responses in SharePoint: us.flow.micros...
Power Automate Support: us.flow.micros...
00:00 Intro
03:21 Step 2: Create the Quiz
03:19 Step 3: Create the List
06:01 Step 4: Use Power Automate to create the Flow
12:35 Step 5: User Power BI to load SharePoint List
15:30 QnA: Can I use other data sources to replace SharePoint?
16:58 QnA: What if I change my question?
18:02 Thank you!

[@zpinally]

Great tips!! but do you have any suggestion, If I would like to correct point score from quiz in sharepoint list?

[@nayanapoojari]

Matthew a question: what connectors we can use to extract data from teams to power BI?

[@mmdpsj]

How do I automatically record or report the quiz score/results in Sharepoint and in PowerBI? (not the quiz response). Please help.

[@gabrielferreiraguimaraes2092]

I looking for this for a week too.

[@lijunchen]

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.

[@lijunchen]

@@gabrielferreiraguimaraes2092 See below. Hope it helps.