A web-based tool in Microsoft 365 that enables users to quickly create surveys, quizzes, polls, and feedback forms.
Dear PowerBI Admin,
Thank you for reaching out.
Please note that the Forms-to-Excel synchronization and Power BI scheduled refresh are separate processes. A Power BI refresh can refresh the data used by the Power BI semantic model, but it does not first trigger the Forms connection inside the Excel workbook to synchronize the latest responses.
For a supported cloud-based approach that does not depend on a local computer, I recommend using a separate Excel workbook as the destination rather than relying on the existing Forms-managed response workbook. Power BI can then use this dedicated workbook as its data source. This removes the requirement to manually open the Forms-linked workbook before refreshing Power BI.
Since you mentioned that you have already tried Power Automate and it did not work, I suggest checking the flow's Run history after submitting a new test response.
Please verify the following:
- Confirm that When a new response is submitted is triggered successfully.
- Confirm that the flow includes Get response details before Add a row into a table.
- Check which action fails and note the exact error message.
- Confirm that the destination range in Excel is formatted as an actual Table.
- Confirm that the Power Automate connection account has edit permission to the workbook in SharePoint.
As an isolation test, I recommend creating a new Excel workbook in SharePoint, creating a simple table with columns corresponding to the Form questions, and configuring the Power Automate flow to write one test response into this workbook.
For reference, please refer to: Common ways to use a form in a flow
If the new response is successfully added without anyone opening the workbook, this will confirm that the cloud-based automation is working and also help determine whether the previous failure is related to the existing Forms-linked workbook or its configuration.
If the flow still fails, I suggest you post on the Microsoft Power Automate Community for expert assistance. This is a specific channel related to Power Automate Microsoft Power Platform Community Forum Thread, you'll get the most qualified group of respondents, and other partners who read the forums regularly can share their knowledge or learn from your interaction.
Apologies for redirecting you to a different community as the members of the posted category focus on users with Microsoft 365 concern and have limited knowledge about Power Automate, so to get a quick and better assistance, I redirect you in the correct way.
I appreciate your patience and understanding and thank you for your time and cooperation.
Hope you have a great day!