# Integrate granular conversational reporting in FlowBuilder with Microsoft Power BI

In this guide, you will learn how to structure a conversation in FlowBuilder and forward the relevant data to Microsoft Power BI’s live-data webhook.

**Why Microsoft Power BI?**&#x20;

Microsoft Power BI allows you to know your customers' choices within any omnichannel conversation, project these data points into Power BI for live dashboards, and access historical reporting.&#x20;

**Requirements**

* [MessageBird account](https://dashboard.messagebird.com/en/sign-up)
* [WhatsApp for Business account](https://www.messagebird.com/whatsapp/) or any other channel from [MessageBird's offering](https://dashboard.messagebird.com/en/channels)
* [Microsoft Power BI account](https://powerbi.microsoft.com/en-us/)

**Step 1: Set up Microsoft Power BI**

Make sure to sign up for a [MessageBird account](https://dashboard.messagebird.com/en/sign-up) and a [WhatsApp for Business account](https://www.messagebird.com/whatsapp/) or one of the [other channels](https://dashboard.messagebird.com/en/channels). Done? Awesome! Time to [sign up for Microsoft Power BI](https://powerbi.microsoft.com/en-us/)&#x20;

1\. [Sign up or log in](https://app.powerbi.com/signupredirect) to Microsoft Power BI

2\. [Create a streaming dataset](https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming):&#x20;

* Select ‘Historical data analysis’ to save data for later usage
* Record streaming dataset URL

<figure><img src="/files/Ax9gkR33Nn0Xz0NkDSNR" alt=""><figcaption></figcaption></figure>

3\. [Create a Power BI Dashboard](https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-create)

4\. [Add a tile and select real-time data](https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#set-up-your-real-time-streaming-dataset-in-power-bi) and select your newly created streaming data set

5\. For this example, choose **Line Chart** and make sure **timestamp** is selected under **Axis**:

<figure><img src="/files/wBnmFXdkqqUAfBPoQKR0" alt=""><figcaption></figcaption></figure>

6\. Done! **Confirm changes**.

&#x20;

**Step 2: Connect it all in the MessageBird Dashboard**

1\. Log in to your [MessageBird Dashboard](https://dashboard.messagebird.com/en/login) and go to [Flow Builder](https://dashboard.messagebird.com/en/flow-builder).

2\. Create three [Webhook flows](https://dashboard.messagebird.com/en/flow-builder/create/custom) and name the flows **Branch-1**, **Branch-2**, and **Branch-3** accordingly. Done? Awesome! Publish and record the webhook URLs of each flow.

<figure><img src="/files/wvOFhjWYnOTVIbbBtuZ9" alt=""><figcaption></figcaption></figure>

3\. Import the [main flow here](https://drive.google.com/file/d/1Nrfwd1xpmKwf3YYdxI-IvMIbqPurnOEp/view?usp=sharing).

4\.  For the first step in the flow, select your **WhatsApp channe**l or your **chosen channel** from [Part 1](https://dashboard.messagebird.com/en/channels).

5\. Look for the step **Replace 1 of 2 - Set URLs of Branch flows** and add the flow URLs of the 3 flows created in step 2.

6\. Look for the step **Replace 1 of 2- Set FlowIDs and API Key** and add the empty objects accordingly:

* Flow IDs can be located in the URLs of each webhook flow.
* Get your Live API key in your [MessageBird Dashboard](https://dashboard.messagebird.com/en/developers/access).

7\. **Publish** your flow in the top-right corner of your screen, and you're good to go!

8\. Done! Every time an end-user engages the main flow and chooses an option from the menu, it will be tallied and forwarded to Microsoft Power BI.

\
And that’s it! 🎉 Now you know how to integrate granular conversational reporting in FlowBuilder with Microsoft Power BI.

\ <br>

&#x20;

&#x20;

\ <br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.bird.com/connectivity-platform/advanced-functionalities/integrate-granular-conversational-reporting-in-flowbuilder-with-microsoft-power-bi.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
