Microsoft Forms data no longer syncing? Here's a workaround for Power BI.

In 2024, Microsoft changed the Microsoft Forms Excel sync. You now need to open the workbook to trigger a sync, which somewhat breaks the ability to automate reporting on the data in Power BI. Here's a workaround that uses Power Automate to send the data to a Microsoft List - if we connect to that instead, it's still usable. You can read the actual announcement from Microsoft here: https://techcommunity.microsoft.com/blog/microsoftformsblog/update-to-the-new-solution-for-syncing-forms-responses-to-excel/4229844 🍀 CHAPTERS 0:00 - Intro 1:07 - Create a Microsoft list to store the data 2:56 - Create the Power Automate flow 6:27 - Test the flow 6:40 - Connect to the data in Power BI 7:24 - Parse the JSON 8:39 - Rename the fields 9:41 - Lists as a source 10:27 - Add a question to your form? Update this step 11:07 - How to custom sort survey response data ▶️ WATCH NEXT How to combine queries in Power BI: https://youtu.be/EsS2xdKgtsA Schedule refresh on SharePoint sources (this example is files, but it applies to lists also): https://youtu.be/ba1Akv63GDQ 🎓 COURSE - I’m working on a course! Join the waitlist here if you’d like an early bird rate and email when its ready: https://bi-ome.kit.com/waitlist CONNECT WITH ME 📩 Get new videos via email! - https://bi-ome.kit.com/youtube 📝 Blog - https://christine-payton.com/ 🔗 LinkedIn - https://www.linkedin.com/in/christinehpayton/ 💬 Questions? Drop them in the comments! Your question could help others too. #forms #msforms #powerbi