How to create a reseller revenue dashboard in Power BI with webhook integration

To create a revenue dashboard for your white-label reseller in Power BI, use Papo webhooks (https://papo.global/) to capture new subscription and payment events in real time. This data feeds a dataset in Power BI that displays MRR, growth, and the financial health of your customer base, without manual exports.

Combining Papo's automatic notifications with Power BI transforms how you track your business. You stop relying on static reports and start seeing revenue evolve minute by minute, enabling faster decisions about pricing, customer base expansion, and customer retention.

Configuration overview

How the integration works

Papo can notify external systems whenever a relevant event for your business occurs. For the revenue dashboard, the focus is on billing and subscription events available in your account. When a customer takes out a new subscription or a payment is confirmed, Papo sends a POST with the data (amount, plan, customer, date) to a URL you configure.

To reach Power BI, an intermediary service — such as Zapier, Make, or Power Automate — receives that POST, converts the payload, and adds a row to a streaming dataset. Power BI then automatically updates the dashboard visuals, reflecting revenue in real time.

Step-by-step

1. Create the streaming dataset in Power BI

In the Power BI service, go to the Streaming datasets area. Create a new dataset and define the columns that will feed the dashboard. Example structure:

• datetime (date and time of the event)
• subscription_id (unique identifier)
• customer (customer name or ID)
• plan (name of the subscribed plan)
• amount (amount in R$)
• event_type (new subscription, renewal, etc.)

Note the dataset name — it will be used in the next step.

2. Configure the intermediary automation (example with Zapier)

1. In Zapier, create a Zap.
2. Choose the Webhook by Zapier trigger with the Catch Hook event. Copy the generated URL.
3. Add a Power BI - Add rows to a dataset (API) action.
4. Connect your Power BI account (OAuth login) and select the workspace and the dataset you created.
5. Map the fields from the received JSON to the dataset columns (customer name, amount, etc.). Zapier automatically interprets the test payload.

After saving and turning on the Zap, the Catch Hook URL will be ready to receive Papo notifications.

3. Configure the webhook in Papo

Papo offers two ways to send the data:

• Native webhooks: in the account's Webhooks section, create a new subscription. Select the available events, such as “New subscription” or “Payment confirmed” (the exact list depends on the enabled modules). Paste the Zapier Catch Hook URL and keep the POST method. The standard payload will be sent; you can keep it if the fields already fit.
• Webhooks via Flows: in the Flows module, create an automation with the desired event trigger. Add the Webhook action, paste the Zapier URL, and, in the message body, build a JSON with the available variables (e.g., {{subscription.value}}, {{customer.name}}). This lets you select exactly the data you need.

In both cases, save and activate. From that moment on, every new subscription or payment will be sent instantly to Power BI.

4. Build and publish the dashboard

With data flowing, open Power BI Desktop, connect to the streaming dataset, and create the visuals:

• Current MRR card (sum of active subscription amounts)
• Monthly growth bar chart (MRR per month)
• Latest subscriptions table (latest customers who joined)
• Revenue daily evolution line chart

Publish the report to the Power BI service and pin the cards to a dashboard. The dashboard will update automatically as webhooks arrive.

Who this solution is for

• Papo white-label resellers who need to monitor the evolution of their customer base and recurring revenue in real time.
• Sales managers who offer modular plans and want to track which plans are selling best.
• Finance teams who need alerts about delinquency or renewal, triggered directly in the dashboard.
• Data professionals who already use Power BI and want to eliminate manual report exports.

Frequently asked questions

Do I need to know how to code to implement this integration?

No. With platforms like Zapier and Make, configuration is entirely visual, with no code. Only creating the dashboard in Power BI requires some familiarity with the tool, but it does not require programming.

Does the data arrive in real time?

Yes. As soon as the payment or subscription event occurs in Papo, the webhook is triggered immediately. Zapier processes the send in seconds, and Power BI reflects the new data in the dashboard almost instantly.

Which payment events are available in Papo?

The list of available events depends on the modules you have contracted and your reseller plan. Check the webhook creation interface to see which billing and subscription triggers appear for your account.

Can I use Power Automate instead of Zapier?

Yes. Power Automate also has connectors for “When an HTTP request is received” (trigger) and “Add rows to a Power BI dataset” (action). The logical flow is the same.

Is there an additional cost for data streaming in Power BI?

The streaming datasets feature requires a Power BI Pro license (or higher). The row limit per hour is generous for reseller scenarios; check Microsoft's official documentation for current limits.

How can I test the integration before activating it?

Create a test subscription or a manual payment in your Papo account. After sending, check whether Zapier received the webhook and whether the row appears in the Power BI dataset. You can also use Zapier's “Test” feature to send a sample payload.

Read also

• How to view the monthly recurring revenue of your white-label reseller
• How to generate usage reports for white-label reseller customers

Start for free →

Create your free Papo account and start automating event capture to build your real-time dashboards today.