Survey results from "Microsoft Forms" or raw data from Excel to OneLake

[CBO2404]

What is the most effective method for importing (automatically) survey results from "Microsoft Forms" or raw data from Excel files ( made by users in the organization) into "OneLake"? The data is currently stored as files in various groups within SharePoint and I would like to use the surveys or the raw Excel data for creating multiple reports for multiple audiences in Power BI.

[CBO2404]

Thank you so much for your comprehensive reply. I know the import in powerbi but I want the raw data in onelake.

[v-yiruan-msft]

Hi @CBO2404 ,

You can follow the steps below to get it:

• In Power BI Desktop, select Get Data > Web.
• In the From Web dialog box, paste the URL of your Microsoft Forms survey. You can find the URL by opening the survey in a browser and copying the link from the address bar. The URL should look something like this: https://forms.office.com/Pages/ResponsePage.aspx?id=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
• Click OK and sign in with your Microsoft account credentials.
• In the Navigator pane, select the table that contains the survey responses. You can preview the data in the right pane.
• Click Load to import the data into Power BI Desktop.

In addition, you can refer the following links to get it.

How to Connect MS Forms to Power BI using Forms for Excel (iterationinsights.com)

The Best Way to use Power BI with Microsoft Forms - Excelerator BI

And about how to create reprot and share the report with others, you can review the following links.

Create report:

Create reports and dashboards in Power BI - documentation - Power BI | Microsoft Learn

Share report:

Share Power BI reports and dashboards with coworkers and others - Power BI | Microsoft Learn

4 Ways to Share Power BI Reports and Dashboards (brightwork.com)

Best Regards