Databases and operations
Power BI automation and integration.
Microsoft's business intelligence tool for reports and dashboards.
- Usually paired with
- Microsoft Teams, Power Automate, BigQuery, Business Central
- Timeline
- Most builds live in 3 to 5 business days from scope
- Owned by
- You, with accounts, credentials and code in your name.
What we build on Power BI
- Prepare and model data from your finance and sales systems
- Refresh a model through the API when a data load finishes
- Send report summaries to Teams or email through Power Automate
- Add a written note on what changed for managers to read with the numbers
What we sync
Workflows we are asked for
- Power BI refresh after data load
- Power BI sales dashboard from a CRM
- Power BI finance reporting from Business Central
- Power BI summary to Teams
Often paired with
Tools Power BI usually needs to talk to.
-
Power BI and Microsoft Teams
Microsoft's app for chat, meetings and channels, usually run alongside Microsoft 365.
-
Power BI and Power Automate
Microsoft's workflow tool, partly included with Microsoft 365, used with Copilot Studio agents by companies already on Microsoft.
-
Power BI and BigQuery
Google Cloud's data warehouse for running SQL across large datasets.
-
Power BI and Business Central
Microsoft Dynamics 365 Business Central, Microsoft's ERP for small and mid-sized companies, covering finance, sales, purchasing and inventory.
In every build
Standards we apply to every build.
Under the hood
- Upserts keyed on the record
Each write is matched on the source ID, so a retry or a re-fired event updates the existing record.
- Retries with backoff
Rate limits and timeouts are retried with increasing delays. If they still fail, they are parked for review.
- Idempotent, loop-safe writes
Two-way flows carry a marker so a change written by the sync does not re-trigger the sync.
- Reconciliation
A nightly job compares counts and totals on both sides and lists any record that differs.
- Audit log
Each run records the input, the mapping result, the action taken and what triggered it. You can search it by record.
For the team
- Slack or email notifications
Alerts go to a named person on your team, by Slack, email or WhatsApp.
- A runbook
One document per integration: what it does, what each alert means, and what to do in the first ten minutes.
- Training
A live session with the people who will use the review queue, recorded for whoever joins later.
- Handover
Admin access, billing and code sit in accounts in your name from the start, so the build keeps running if we stop working together.
- Sixty days of hypercare
The engineers who built it stay on call after go-live, fix what breaks and tune what the team asks for.
Keys and data
- Keys are kept in a vault
API keys and tokens are stored in the orchestration layer's encrypted credential store or the platform's secret manager. None are written into workflows, repos, spreadsheets or chat.
- One credential per connection
Each integration gets its own key, scoped to the objects and actions it needs. A lead sync cannot read invoices. Revoking one key stops one thing.
- Service accounts for connections
Connections use a dedicated service user in your account, so nothing breaks when a person leaves and nothing runs under someone's name.
- Two-factor on every account
Each platform account we set up has two-factor authentication on, and the recovery codes are handed to you.
- Rotation on handover and on request
Keys are rotated when the build is handed over, when anyone with access leaves, and at any time you ask.
The offer
Connect Power BI to the rest of your stack.
We agree a fixed scope in a discovery call, and most builds go live in three to five business days. The accounts are in your name, and the engineers who built it stay on call for sixty days after.
- ScopeOne call to agree the workflows, the fields and the owner, written up the same day.
- BuildValidation, upserts, retries, reconciliation and an audit log, on n8n, Make or code.
- Go-liveWe test in a sandbox first, then switch over. It takes longer only where a vendor has to approve something.
- HandoverRunbook, training session, alerts to a named owner, admin access and code in your accounts.
- AfterSixty days of hypercare, then a care plan or run it yourself.
Questions
What people ask about Power BI.
Can you trigger Power BI refreshes from a workflow?
Yes, through the Refresh Dataset REST API. Enhanced refresh, which adds table-level refresh and cancellation, needs a model in Premium, Premium per user or Power BI Embedded, so we check your licence first.
Power BI
Start with the one Power BI workflow your team still runs by hand.
Bring it to a discovery call. You leave with a yes or no on fit, an outline of the build and what we would do first.
Book the call