Forum Discussion

StevenT's avatar
StevenT
Icon for Helper V rankHelper V
1 year ago
Solved

Connecting Microsoft forms to powerbi

Hi, I'm a home user with microsoft 365 and powerbi pro license. I want to learn how to connect forms and powerbi together.  But I don't have sharepoint. How would you suggest i connect forms to p...
Need Help
  • Expiscornovus's avatar
    Expiscornovus
    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. 

  • Anonymous's avatar
    Anonymous
    1 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

yak_designid's avatar
yak_designid
Frequent Visitor
1 year ago

There is an even easier method as long as your microsoft forms responses are saved in a web-hosted excel spreadsheet (whether it is in One Drive or Sharepoint does not matter).
Just copy the link to the excel file (delete the last few characters of the link to make sure that the link ends in ".xlsx").
Go to Power BI:
Get data = Web
Paste your link to the excel file and it will import it for you.
Every time you refresh, it will be imported into Power BI.