Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
CBO2404
Helper I
Helper I

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

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.

2 REPLIES 2
CBO2404
Helper I
Helper I

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
Community Support
Community Support

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.

vyiruanmsft_0-1689926992164.png

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.