Last updated
Last updated
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
or any other channel from
Step 1: Set up Microsoft Power BI
Make sure to sign up for a and a or one of the . Done? Awesome! Time to
1. to Microsoft Power BI
2. :
Select ‘Historical data analysis’ to save data for later usage
Record streaming dataset URL
5. For this example, choose Line Chart and make sure timestamp is selected under Axis:
6. Done! Confirm changes.
Step 2: Connect it all in the MessageBird Dashboard
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.
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.
3.
4. and select your newly created streaming data set
1. Log in to your and go to .
2. Create three and name the flows Branch-1, Branch-2, and Branch-3 accordingly. Done? Awesome! Publish and record the webhook URLs of each flow.
3. Import the .
4. For the first step in the flow, select your WhatsApp channel or your chosen channel from .
Get your Live API key in your .