Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

PowerBI and MS Forms Quiz

I have a MS forms quiz with a flow to a list to extract to use Power BI. The flow is working for all the answers to the questions but flow does not allow to bring over the scores from the MS Form quiz and therefore the list does not generate the results columns. In Power BI I have tried a direct connect to the form and unable to. Would like to bring MS Form-Quiz directly into Power BI so I can get scores for each of the questions. Please let me know what the best possible solution is. Thanks

 

Need Help

1 Reply

  • Bhaktishete's avatar
    Bhaktishete
    New Member
    2 years ago

    Try to use Excel as an Intermediate Step

    1. Export Form Responses to Excel:

      • Export the responses from Microsoft Forms to an Excel file. This can be done manually or automatically using Power Automate.

    2. Calculate Scores in Excel:

      • In the Excel file, add formulas to calculate the scores for each question based on the responses.

    3. Connect Power BI to Excel:

      • Import the Excel file into Power BI and use the calculated scores for analysis and visualization.