Microsoft Forms data no longer syncing? Here's a workaround for Power BI. скачать в хорошем качестве

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/b... 🍀 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:    • How to COMBINE Tables in Power BI   Schedule refresh on SharePoint sources (this example is files, but it applies to lists also):    • How to Schedule REFRESH on File & Folder S...   🎓 COURSE https://christine-payton.com/course/ CONNECT WITH ME 📩 Get new videos via email! - https://bi-ome.kit.com/youtube 📝 Blog - https://christine-payton.com/ 🔗 LinkedIn -   / christinehpayton   💬 Questions? Drop them in the comments! Your question could help others too. #forms #msforms #powerbi