Forum Discussion
Connecting Microsoft Form to Power BI
Hello,
I'm trying to connect my microsoft form data to Power BI, i tried following this tutorial : Easiest Way to Connect to Microsoft Forms Data in Power BI - BI Elite and my URL does the same thing as in the tutorial (downloading the excel file associated to my form's answers).
But i'm getting the following errors when i try to connect to the web content :
I tried editing and deleting the credentials but it doesn't change the error, do you know where it might be coming from ?
Best regards,
MD
9 Replies
- BIntelligence
Helper I
Anonymous I had to implement a workaround. Created a SharePoint list plus a Power Automate cloud flow that runs when a new response is received. Responsedata is now stored in the SharePoint list which I use as datasource in Power BI.
- BIntelligence
Exactly same over here. Haven't found a solution yet. Too bad this doesn't work anymore.
This is still an issue. I hope it gets resolved soon.
I have the same problem. Has anyone found a fix for this? Thank you.
- BIntelligence
No fix but afterall I'm happy with the workaround storing responses in a SharePoint list. Gave me the opportunity to correct some mistakes respondents made.
Hi, I found this alternative to work really well for me, described by user Mathew Parowski on another MS forum.
It's not directly Forms, but it also doesn't involve using Power Automate as other options do.
- christinepayton
Most Valuable Professional
If your form is linked to a M365 group, it will sync your data to an Excel file in the linked SharePoint site that you can connect directly to in PBI. I have a video on how to do this here: https://youtu.be/HgFGyBbpMCA
If your Form isn't currently associated with a group, you can associate it with one in the Forms web app.
One workaround I use is to host an excel sheet on SharePoint. I use PowerAutomate to add each new response to the excel sheet as a new row. This also allows me to edit responses as needed. It is easier to change one cell in excel than it is in Power Query/Power BI. However, I have a need for a form where responses can be revisited and added to/amended. If anyone has a method of capturing data from the form directly that can refresh old form submissions that were updated, similar to an API as opposed to a flow of resopnses to a new static data storage system, please let me know! This would be very very beneficial!
