Blog Post

Microsoft Forms Blog
2 MIN READ

New data sync solution is now supported in forms created from SharePoint, OneDrive and Teams

junyuB's avatar
junyuB
Icon for Microsoft rankMicrosoft
Nov 01, 2024
We have been gradually updating the Forms data sync to Excel to a new solution since August, and we're excited to announce that it’s now fully available in group forms, no matter created through Form...
Create Forms survey from SharePoint
Updated Dec 13, 2024
Version 3.0
microsoft 365
microsoft forms
ZiJon's avatar
ZiJon
Copper Contributor
Jan 21, 2025

Well... as clearly stated in previous blog post "With the new syncing solution, you must open the Excel app to receive new responses. Otherwise, they will not sync to the workbook." so my workflow to use Microsoft Power BI to retrieve form's data from the Excel Online file on predefined in Power BI service schedule is broken. To use Power Automate fix is not an option for me. So, I wrote a simple PowerShell script that periodically opens Excel Online file in browser, waits for it to update and then closes. The script opens supplied URL(s) every 6 hours just before Power BI scheduled data source update. Now I run the script from always signed-in user account on Windows Server that is always online and see my Power BI reports get automatically updated.

You can try the script on your local machine and leave it powered on or find a dedicated Windows machines for this task.

GitHub - ZilvinasJonaitis/OpenCloseBrowser

Regards,

Zilvinas