Forum Discussion
Microsoft Forms - new error message preventing refresh
Yesterday I set up a workaround to load a long running MS form into Power BI (as exporting a spreadsheet each month is really annoying!) I used this video by Bielite https://bielite.com/blog/mic...
Instead of risking this connection breaking again, I used PowerAutomate to pull the form results into an Excel on onedrive.
This had the added bonus of allowing me to fix some small errors in previous entries (which was proving complicated in Transform due to the fact that they weren't simple find and replace).
Hopefully this will remain a more sturdy option!
C