Keep Otto and Power BI updated automatically.
Today you sign in to the seller account, look at what sold and carry it over by hand. What you already processed you track somewhere else. With this connector, what happens in Otto lands in Power BI by itself, in the shape Power BI expects. Request it and you get access; you hear from us within 24 hours.
What this connector takes off your hands
-
Today you sign in to the seller account, look at what sold and carry it over by hand. What you already processed you track somewhere else.
-
Today you create the task or the row yourself, or you just remember it and that fails eventually.
What Otto to Power BI saves you
- Turn every new Otto order into a Power BI task automatically.
- Turn every Otto return into a Power BI task automatically.
- Turn every Otto payout into a Power BI task automatically.
- Turn stock running low on Otto into a Power BI task automatically.
- Turn every cancellation on Otto into a Power BI task automatically.
What travels across the link
Everything this connector moves between Otto and Power BI, and how often.
-
Tasks
to Power BI automaticallyThis lands in Power BI as a task in the list or project you choose, so follow-up does not depend on someone remembering.
-
Rows
to Power BI automaticallyThis arrives in Power BI as a new row, so your overview stays complete without you retyping anything.
What each side expects
Otto and Power BI do not describe the world the same way. This is what has to line up.
Otto
A marketplace supplies orders with their own order number and their own lines, plus returns and cancellations that arrive separately.
Power BI
A task list or table wants to know where something belongs, and only stays usable with a fixed layout.
Setting it up
- 01
Request the connector
Request the Otto to Power BI connector and get access. You hear from us within 24 hours.
- 02
We agree what should travel
Together we settle what should travel out of Otto. A task list or table wants to know where something belongs, and only stays usable with a fixed layout.
- 03
Test and switch on
You check the connector on a few test records before anything becomes final, then it runs by itself.
What you need
- A seller account with API access, created from within the account itself.
- An account with edit rights, and the list or project it should land in.
Where it runs
On app.schakel.app, with your own Schakel account. No webshop required.
Request this connector: tell us what you need and we reply within 24 hours.
Common questions
Can you connect Otto to Power BI?
Yes. Schakel connects through the official APIs of Otto and Power BI, so you install nothing on your own server and nothing travels outside those two parties.
Which Power BI project or list do the tasks land in?
The project or list you choose. That keeps everything in one place rather than scattered, and follow-up does not depend on someone remembering.
Can I decide what goes into the Power BI task or row?
Yes. When setting it up you pick which details from Otto come along, so a task or row in Power BI has just enough context.
Do I still have to log into Otto once the connector runs?
No. Once it runs, everything you now look up in the Otto seller account arrives in Power BI by itself. You only open Otto when you want to check something yourself.
What does connecting Otto and Power BI cost?
You start free and only pay once the connector is really running. After that the same tiers apply as for any other connector, based on how much runs through it each month.
How often does Otto sync with Power BI?
That depends on your tier: hourly on the free tier up to real time on the unlimited tier. You can always start a sync yourself as well.
Does the connector also pick up Otto returns and cancellations?
Yes. Besides new orders, Schakel also sees returns and cancellations on Otto, so Power BI does not lag behind what actually sold.
What if Otto or Power BI is briefly unavailable?
Nothing gets lost. Schakel retries later and the log shows exactly what happened, so at most you notice something coming through a little later.
Connect a different pair
Otto and Power BI is one of many. Pick two systems and see what travels between them.
Missing something you need?
Tell us what Otto and Power BI should do for you. If it is not in here yet, that is usually because nobody has asked. We build on request and we reply within 24 hours.