How to Connect Microsoft Forms to Power BI

Ever wished you could turn your Microsoft Forms survey results into a dynamic Power BI dashboard without manually exporting a spreadsheet every time? You can, and setting it up is easier than you think. This article will walk you through, step-by-step, how to create an automated workflow that sends new form responses directly into a Power BI report for real-time analysis.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Connect Microsoft Forms to Power BI?

While the built-in analytics in Microsoft Forms are useful for a quick glance, connecting it to Power BI unlocks a new level of reporting. The core benefits essentially come down to automation and deeper, more dynamic insights.

• Real-Time Updates: Stop downloading CSV files. As soon as a response is submitted, your Power BI report updates automatically. This is perfect for tracking event registrations, live feedback during a webinar, or ongoing customer satisfaction surveys.
• Powerful and Interactive Visualizations: Move beyond the basic charts in Forms. In Power BI, you can slice and dice your data with interactive filters, create custom visuals, and design dashboards that tell a compelling story with your survey results.
• Data Consolidation: Your survey data rarely lives in a vacuum. Power BI lets you combine your Forms responses with other key business data. You could, for example, merge customer feedback from a form with sales data from your CRM to see how satisfaction scores impact purchase behavior.
• Set It and Forget It: Once you complete the one-time setup outlined below, the entire process runs on its own. You build the data pipeline once and then focus your energy on analyzing the insights, not on manual data entry.

Understanding the Workflow: Forms → Power Automate → Power BI

It's important to know that Microsoft Forms doesn’t have a direct, native connector to Power BI. To link them, you need a helpful tool in the middle: Power Automate (formerly known as Microsoft Flow).

Power Automate acts as the bridge that listens for activity in one application and triggers an action in another. The workflow is simple and logical:

1. Trigger: A user submits a new response in your Microsoft Form.
2. Action: Power Automate detects this new submission and fetches the details of that specific response.
3. Action: Power Automate then sends — or "pushes" — those details into a real-time dataset you’ve set up in Power BI.
4. Result: Your Power BI report, which is connected to this dataset, updates instantly.

Let's walk through building this exact workflow.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Prerequisites: What You’ll Need

Before you begin, make sure you have access to the following from your Microsoft 365 account:

• A Microsoft Form: You'll need an existing form to connect. For this tutorial, a simple feedback survey with a few questions (e.g., a name, a rating on a scale of 1-10, and a text comment) works perfectly.
• Power BI: You need a Power BI Pro or Premium account to create streaming datasets and share your reports with others. The free version has limitations here.
• Power Automate: This is included with most Microsoft 365 business plans. You don’t need a special license for this workflow.

Step-by-Step Guide: Connecting Forms to Power BI

Follow these four steps to build your automated pipeline. We'll start by preparing the destination in Power BI and then build the flow that sends data to it.

Step 1: Set Up Your Power BI Streaming Dataset

First, you need to create a "container" in Power BI to receive the incoming data from your form. This is called a streaming dataset.

1. Log in to the Power BI service at app.powerbi.com.
2. In the left navigation pane, select the workspace where you want your report to live.
3. Click the + New button in the top-left and select Streaming dataset.
4. Choose the API tile and click Next.
5. Now, you have to define the structure of your data. For the "Dataset name," give it something descriptive like "Live Customer Feedback."
6. Under "Values from stream," you need to add a row for every question on your form. This is a critical step. Make sure the "Data type" you select in Power BI matches the kind of answer you expect (Text, Number, or Datetime).

For example, if your form asks three questions:

• What is your name? (Text response)
• How would you rate our service? (1-5 scale)
• Any additional feedback? (Long text response)

You would create three values like this:

• Value name: Name, Data type: Text
• Value name: Rating, Data type: Number
• Value name: Feedback, Data type: Text

Finally, and this is a pro tip, toggle "Historic data analysis" ON. If you leave this off, Power BI will only display the LATEST value sent. Turning it on tells Power BI to store every response it receives, allowing you to build historical reports, track trends, and analyze all the data over time.

Click Create. Power BI will show you some code snippets and a URL. You can ignore this and simply click Done. We don't need this information because Power Automate will handle the connection for us.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Create a Flow in Power Automate

Now that your destination is ready, let's build the workflow in Power Automate.

1. Navigate to make.powerautomate.com and log in.
2. From the left menu, click Create and choose Automated cloud flow.
3. Give your flow a name, like "Send Form Responses to Power BI."
4. In the search box under "Choose your flow's trigger," type "Microsoft Forms" and select the trigger named When a new response is submitted.
5. Click Create.
6. In the trigger box, click the dropdown for "Form Id" and select the Microsoft Form you want to pull data from.

This is the starting point. The flow will now run every time this specific form gets a new submission.

Step 3: Get the Details of the Form Response

The trigger only tells the flow that a response happened, not what the answers were. Our next step is to retrieve those answers.

1. Click the + New step button below the trigger.
2. Search for Microsoft Forms and select the action named Get response details.
3. For the "Form Id," select the same form you chose in the trigger step.
4. For the "Response Id," click inside the field. The Dynamic content panel will appear on the right. Select Response Id from the list. This tells the flow to get the details for the specific response that just came in.

Step 4: Send the Data to Your Power BI Dataset

This is the final action where you map the form answers to the Power BI dataset you created.

1. Click + New step again.
2. Search for Power BI and choose the action Add rows to a dataset.
3. Select the Workspace and Dataset where you created your streaming dataset in Step 1. The Table name will automatically populate to RealTimeData — leave it as is.
4. You will see fields that match the values you defined in your streaming dataset (e.g., Name, Rating, Feedback). Now, you just need to map them.
5. Click inside the box for Name. From the Dynamic content panel, find the question from your form that corresponds to the name and select it. Do the same for Rating and Feedback, matching each field in Power BI to the correct question from your form.

Your finished Power Automate flow should have three simple steps. Click Save in the upper right corner.

Putting It All Together: Testing and Building Your Report

Your automated pipeline is now built. Let's test it out.

1. Go to your Microsoft Form and submit a new test response.
2. Give it about 30 seconds, then navigate back to your Power BI workspace.
3. You should see your new streaming dataset. Click the three dots (...) next to it and select Create report.
4. You are now in the Power BI report builder. On the right, in the Data pane, you'll see the fields you created: Name, Rating, Feedback, etc. You can now drag these fields onto the canvas to create visuals.

Try creating a few simple visuals to see your data:

• Select the "Card" visual and drag your "Rating" field into it. Right-click "Rating" and choose "Average" to see the average score in real time.
• Select the "Table" visual and add the "Name" and "Feedback" fields to see all the qualitative comments as they come in.

As you submit more form responses, you'll see these visuals update automatically without needing to hit refresh. Once you are happy with your report, save it. You can then pin your visuals to a Power BI dashboard to create a centralized view of your live survey results.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Troubleshooting Common Issues

If things aren't working as expected, here are a couple of common issues and how to fix them:

• My flow isn't running: In Power Automate, check the 28-day run history for your flow. Is it failing? If so, open the failed run to see exactly which step has an error. Also, confirm you've selected the correct form in the trigger step.
• My data isn't showing up in Power BI: A flow might run successfully but still not populate data if there is an issue with the "Add rows to a dataset" step. The most common cause is a data type mismatch — for instance, trying to send a text answer like "N/A" into a Power BI field that's defined as a Number. Make sure the data types align between your Form, Flow, and Power BI dataset.
• I can't see my old form responses: This automation process only works for new submissions that occur after the flow is turned on. It does not automatically import historical data. To analyze previous responses, you'll first need to export them from Forms to an Excel file and then connect Power BI to that file separately.

Final Thoughts

By using Power Automate as the bridge, you’ve successfully built a powerful, automated pipeline for analyzing Microsoft Forms submissions in Power BI. This lets you move from manual, static reporting to a dynamic, real-time dashboard that provides constant insights as new data arrives.

Automating workflows like this is incredibly useful, but managing connections and building reports across all your different tools can quickly become an exercise in complexity. At Graphed, we focus on simplifying this entire process by connecting to all your marketing and sales sources — from Google Analytics and Facebook Ads to Shopify and Salesforce — in seconds. We allow you to create live dashboards using simple, natural language, freeing you from juggling different reporting tools. If you’re looking for a quick and easy way to create a single source of truth for your business performance, you might enjoy using Graphed.