Integrate granular conversational reporting in FlowBuilder with Microsoft Power BI
PreviousIntegrate MongoDB and Omni-Channel automation with FlowBuilderNextMaking an API request and formatting the results in a Flow Function
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
WhatsApp for Business account or any other channel from MessageBird's offering
Step 1: Set up Microsoft Power BI
Make sure to sign up for a MessageBird account and a WhatsApp for Business account or one of the other channels. Done? Awesome! Time to sign up for Microsoft Power BI
1. Sign up or log in to Microsoft Power BI
2. Create a streaming dataset:
Select ‘Historical data analysis’ to save data for later usage
Record streaming dataset URL
3. Create a Power BI Dashboard
4. Add a tile and select real-time data and select your newly created streaming data set
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
1. Log in to your MessageBird Dashboard and go to Flow Builder.
2. Create three Webhook flows 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 main flow here.
4. For the first step in the flow, select your WhatsApp channel or your chosen channel from Part 1.
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.
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.
