# 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?** 

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. 

**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/) 

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): 

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

<figure><img src="https://675349995-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUJNEE9TMK4fU91VKstBr%2Fuploads%2Fgit-blob-80c44640789cc06e1c5e32d871e0d8f7e3e45ffa%2Fimage3.png?alt=media" 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="https://675349995-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUJNEE9TMK4fU91VKstBr%2Fuploads%2Fgit-blob-4b01c9c302fe7a6b3e69cdb246d753485b82719d%2Fimage1.png?alt=media" 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="https://675349995-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUJNEE9TMK4fU91VKstBr%2Fuploads%2Fgit-blob-a88ed8fa6c197eb0815d2f708049f797c92fab02%2FScreenshot_2020-07-27_at_11.05.29.png?alt=media" 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>