Forum Discussion
gingerclaire
Helper III
Helper IIIMicrosoft 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...
gingerclaireHelper III
Helper IIIInstead 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