Power BI

Connect Power BI

Power BI builds reports and dashboards on a dataset, but your Bol.com sales sit in a portal Power BI does not simply ingest. So you model on manual exports that keep going stale. Schakel brings the sales data from Bol.com and your webshop into a source Power BI can ingest, so your revenue, orders and products sit in a dataset that keeps your dashboards current.

Systems · 145
From
To

Power BI

What travels with Power BI

  • Orders in your dataset

    Every order arrives as a row with amount, products, date and channel in the source your Power BI model runs on.

  • Revenue per channel and period

    Sales from Bol.com and your webshop come together, so you can compare per channel and period in your model.

  • Products and order value

    Product lines and order value come along, so you can measure margin, top sellers and average order.

Why connect Power BI

  • Model on a current dataset, no manual exports.
  • Your Bol.com revenue is in your Power BI reports too.
  • Compare channels, products and periods in one model.
  • Less time spent gathering and cleaning figures.

How it works

  1. 01

    Connect your sales channel

    Connect Bol.com or your webshop to Schakel with an API key, so the sales data flows to your source.

  2. 02

    Ingest the source in Power BI

    Choose the source Power BI ingests, a database or sheet for example, and build your model on the fields that come in.

  3. 03

    Your dashboards stay current

    New orders appear in your source automatically, so your reports move with a refresh.

Your channels into Power BI

A few examples, many more Power BI koppelingen are possible. Do not see yours? Request it and we set it up.

Webshop platforms

Marketplaces

Power BI, common questions

Can I connect Bol.com to Power BI?

Yes. Request this connector and get access; your Bol.com sales then land in a source Power BI ingests, ready for your reports.

Which source does the data land in?

We deliver the sales data into a source Power BI can ingest, a database or sheet for example. Request the connector and we walk through the setup with you.

Does this work with multiple sales channels?

Yes. Besides Bol.com you can connect your webshop, so you compare all sales in one model.

A Power BI connection you do not see here?

Tell us which system Power BI should connect to. Request it and you get access; you hear from us within 24 hours.