Datplan guides

Practical answers for API reporting and local BI workflows

Find direct answers to the awkward reporting questions that cloud-system help pages often leave unresolved: offline access, local reporting copies, scheduled exports, Power BI without another cloud warehouse and moving beyond repeated Excel downloads.

Offline and local control

Use the latest successfully synced reporting data locally

Xero offline reporting

Can I view Xero reporting dashboards offline?

What remains available after a successful Datplan sync, what still requires internet access and how to avoid mistaking a local snapshot for live Xero.

Read the guide →

Business continuity

What Xero reporting can I still access during an outage?

Prepare a useful local reporting snapshot, understand its timestamp and refresh safely when Xero becomes available again.

Read the guide →

HubSpot offline reporting

Can I review HubSpot dashboard data offline?

Use the latest local company, contact, deal and activity reporting data while preserving the boundary between offline review and a live CRM.

Read the guide →

Backup terminology

Local reporting copy, archive or restorable backup?

Understand exactly what each term means and what Datplan provides without making an unsupported restore claim.

Read the guide →

Easy recurring exports

Replace repeated manual downloads with a visible schedule

Scheduled Xero export

How to schedule a local Xero reporting-data export

Select the workspace, Xero organisation, frequency, output and stable folder, then verify both the Datplan run and downstream report refresh.

Read the guide →

Scheduled HubSpot export

How to schedule HubSpot reporting files locally

Refresh supported CRM grains and write consistent files for dashboards, Excel or Power BI without maintaining a custom API script.

Read the guide →

No-code API pull

How to pull Xero API data without writing code

Datplan handles its supported authorisation, endpoint and pagination workflow while keeping accounting meaning and reporting grains visible.

Read the guide →

CRM activity export

How to export HubSpot calls, emails and meetings for reporting

Use the supported Activities grain for sales-work analysis without multiplying deal values or treating CRM activity as revenue.

Read the guide →

Power BI and Excel

Prepare the local data layer before building the report

Xero + Power BI

How to build a local Xero-to-Power BI workflow

A step-by-step file-based approach, what Datplan prepares and what still needs to be configured in Power BI.

Read the guide →

HubSpot + Power BI

How to refresh HubSpot reporting without hand-coded API pagination

Separate extraction, grain selection, stable exports and downstream Power BI refresh checks.

Read the guide →

Xero data model

How to prepare a Xero star schema for Power BI

Choose the fact grain, use dimensions safely and prevent duplicated totals before adding visuals or DAX measures.

Read the guide →

Excel workflow

Why cloud accounting data still ends up in Excel

Built-in reports have limits. Make the inevitable local analysis stage repeatable, reviewable and easier to refresh.

Read the guide →

API and control fundamentals

Understand the limits before automating

API fundamentals

Accounting APIs for reporting: a beginner’s guide

Understand authorisation, endpoints, pagination, rate limits, checkpoints, grains and reconciliation.

Read the guide →

Reliability

How API rate limits affect accounting data sync

Distinguish Datplan plan allowance from provider quota and design a safer refresh schedule.

Read the guide →

Privacy and control

A local reporting-data security checklist for finance teams

Evaluate the device, exports, backups, support diagnostics and later BI sharing—not just the connector.

Read the guide →

See Datplan with real reporting data—without connecting a live account

The Windows app is free to download and includes Datplan Demo data, so you can test sync, dashboards, reporting grains and exports first.