Forum Discussion
Import multiple Microsoft Forms to Power BI
Hello everyone,
I need some help to a problem. Every week i have a meeting with different subjects, at the end of every meeting i have to send a Microsoft Forms with different questions for the week subject. Is there any way to automate the process creating a folder in SharePoint and throwing the forms file every week, to analyze the data in PowerBI?
I thought about transposing the questions to line, so i can have a table like this:
+-----------------------+----+--------+---------+------------------+------------------+------------+----------+
| Form Name (file name) | ID | Name | Email | Starting Time | End Time | Question | Answer |
+-----------------------+----+--------+---------+------------------+------------------+------------+----------+
| Form 1 | 1 | Name 1 | Email 1 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 1 | Answer 1 |
| Form 1 | 1 | Name 1 | Email 1 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 2 | Answer 1 |
| Form 1 | 2 | Name 2 | Email 2 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 1 | Answer 1 |
| Form 1 | 2 | Name 2 | Email 2 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 2 | Answer 2 |
| Form 2 | 1 | Name 1 | Email 1 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 3 | Answer 3 |
| Form 2 | 1 | Name 1 | Email 1 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 4 | Answer 4 |
| Form 2 | 2 | Name 2 | Email 2 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 3 | Answer 3 |
| Form 2 | 2 | Name 2 | Email 2 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 4 | Answer 4 |
+-----------------------+----+--------+---------+------------------+------------------+------------+----------+
But i don't know if this is possible, can someone help me?
Sorry had missed that slightly. I think if careful you can make it work.
1) Find out where it's saving to.2) Name forms with consistent start (will need it later)
3) Use files from sharepoint folder.
4) Combine but then transform and do an unpivot.
I'll try and mock something up and give better instructions later but principal should work.
4 Replies
- bcdobbs
Community Champion
Forma stores it's results in an excel file either in your one drive or if you associate with a team it stores it in associated sharepoint. If you go to view response and open the excel file it will show where it is stored.
You can connect direct to it from power bi.
If you do want to copy it have a look at Power Automate.
- bcdobbs
Sorry had missed that slightly. I think if careful you can make it work.
1) Find out where it's saving to.2) Name forms with consistent start (will need it later)
3) Use files from sharepoint folder.
4) Combine but then transform and do an unpivot.
I'll try and mock something up and give better instructions later but principal should work.