How to build MS Forms reports the right way

Building reports from Microsoft Forms can be a challenge, here's how to do it the right way!
👉 Watch next - • Building great Deneb G...
I created 2 GPTs, try them out here:
🤖1: The PMO Pro, assists a project manager with anything PM-related (based on PMI, Scaled Agile or OKR). bit.ly/The_PMO_Pro
🤖2: Vicky Vega, assists Power BI report creators in building custom visuals using Vega or Vega-Lite (a JSON code that is used in the Deneb custom visual). bit.ly/VickyVega
*) Using GPT's requires a ChatGPT Plus subscription.
📨 The TPC Newsletter (subscribe to get free content):
eepurl.com/dsm7dj
⌛ Learn about timeline visuals in Power BI:
• Timeline visuals in Po...
📊 In case you need a Gantt chart visual in reports:
• GANTT charts in Power BI
📆 Calendar visuals inside Power BI:
• Calendars in Microsoft...
🚀Projectum Power PPM:
projectum.com/power-ppm/
📜The Project Corner blog:
www.theprojectcornerblog.com
LET'S CONNECT:
🧑‍💼 Follow Me On LinkedIn- / erikvanhurck
🐦 Follow Me On X - / erikvanhurck
Chapters:
0:00 Introduction to Forms
1:00 Native reports
1:50 Excel download
2:50 Building Forms, the right way
6:18 The “hidden” feature
9:00 Building the Power BI report
11:00 Correcting old Forms

[@RichWeller]

Thanks for sharing Erik. My team stumbled into this a few months back...GAME CHANGER!!!!

[@TheProjectCorner]

Thanks Rich, it really is 👍🏻

[@ThomasDavid-bs2il]

Do you know how to make the online Excel file read-only for non-admins while still giving them to rights to fill in the form and save it so it gets saved in the Excel?
When making it read-only now, when the users fill in the form it doesn't get added to the Excel.
Thanks!

[@TheProjectCorner]

Hi ThomasDavid, I don't think that's a posibility. On the one hand you don't want them to edit, and on the other you actually need them to.
A posibility could be to hide the file and only show the file in a administrator overview or Power BI report.
Thanks for sharing your thoughts.