Forum Discussion
Connecting Microsoft forms to powerbi
- 1 year ago
Hi StevenT,
What is your aim of the connection? Do you want to present the results/answers in Power BI?
You could for example create a Power Automate flow which triggers when a new response is submitted and store this in a data source (this could for example be an Excel file on your OneDrive) via that flow. After that you could use that data source in your Power BI report.
- Anonymous1 year ago
Hi StevenT ,
As Expiscornovus said, please consider creating an excel in onedrive, creating a flow get the submitted form data and saving the data to the excel in onedrive. Then you can get the excel data from power bi.
//Create an excel file and create a table with column name.
// Please note that using flow requires a power automate license
Best Regards,
Wearsky
Hi StevenT,
What is your aim of the connection? Do you want to present the results/answers in Power BI?
You could for example create a Power Automate flow which triggers when a new response is submitted and store this in a data source (this could for example be an Excel file on your OneDrive) via that flow. After that you could use that data source in your Power BI report.