Sharepoint Excel not automatically syncing responses from MS Forms until opened

The recent MS Forms update done messed up the syncing of SP Excel wherein responses from MS Forms are being synced to. My dataset in Power BI is currently connected to the SP Excel containing the MS Forms responses and even though the scheduled refresh for the dataset is pushing through, it is not displaying the latest records unless I open the SP Excel and a "Syncing.." status will appear. Only then will I be able to refresh the dataset in Power BI containing the latest records.

What would be the best workaround to update the Excel file in Sharepoint automatically once a response in MS Forms is added?