accoTOOL
Free trial
accoMASTERDATA

Master data management, inside Power BI.

Maintain clean, reliable master data directly in your reports. accoMASTERDATA adds extended validation and precision to writeback, so dimensions, lists and hierarchies stay consistent everywhere.

Product master, accoMASTERDATA Power BI
Code Product name Category Status
P-1042Titanium HubComponents Active
P-1043Alloy BracketAssemblies Active
P-1044Components ▾—
✓ Validated · written to SQL

Extended validation

Advanced input rules, including regex, enforce data quality at the point of entry.

Advanced dropdowns

Cascading, data-driven dropdowns keep every choice valid across millions of combinations.

Paste from Excel

Copy-paste ranges straight from Excel into the grid, validated on the way in.

Approval workflows

Route changes through approval before they become the official record.

Change log & audit

Every change is stored in the database, giving a full change log and audit trail.

Same architecture

Built on the same writeback engine as accoPLANNING, reuse your model and hierarchy.

Why accoMASTERDATA

The master-data tool closest to Power BI

No third-party modeller, no separate MDM platform, no retraining. Governed master data lives in the report your business already uses.

✓
Works with any Power BI model
Reuse existing models, no new interfaces.
✓
Native Power BI security
Respects the row-level security you already have.
✓
Supports all DAX
Leverage your existing calculations and skills.
✓
Own your data
Stored in your Azure, Fabric or on-prem SQL.
✓
No extra tools needed
No servers, apps or interfaces to maintain.
✓
Low cost, easy to maintain
From $6.7/user/mo, a fraction of a dedicated MDM suite.
Watch accoMASTERDATA

Master data, maintained in Power BI

A short walkthrough of creating, editing and governing master data directly in your report, written straight back to your own SQL database.

accoMASTERDATA explainer video
Popular use cases

Governed data, maintained by the business

Wherever a business user needs to keep a list, a mapping or a dimension correct, accoMASTERDATA replaces the rogue spreadsheet.

Product lists, HR data & account mappings
Keep reference data current without IT tickets.
Dimensions & extended metadata
Add attributes and ad-hoc dimensions on the fly.
Status confirmation & approvals
Confirm, approve and sign off records in-report.
Payables, receivables & row-level comments
Annotate and maintain operational records.
Supported features
✓ Insert, update & delete rows
✓ Text, number, boolean & date input
✓ Lock cells & columns by condition
✓ Dynamic dropdowns from DAX logic
✓ Edit / read-only modes
✓ Custom column calculations
✓ Regex & rule-based validation
✓ Row-level security
✓ Row-level comments
✓ Full change log & audit
FAQ

Master data in Power BI: questions

Can I edit master data in Power BI?

Not with Power BI on its own: reports are read-only. accoMASTERDATA adds a visual where the owner of a record can create, edit and maintain master data directly in the report, and every change is written back to your database.

Do I need a separate MDM platform?

Not for maintaining the hierarchies, mappings and dimension records your reporting depends on. If you need an enterprise-wide golden record synchronised across many operational systems, a dedicated MDM platform may still be the right choice.

How do validation and approvals work?

Entries can be checked with validation rules and dropdowns before they are saved, and changes can go through an approval step. Every change is logged, so you can see who changed what and when.

Where is the master data stored?

In your own database: Azure SQL, Microsoft Fabric or on-premise SQL Server. Power BI security and row-level security still apply.

How much does accoMASTERDATA cost?

Writeback users cost $15 per user per month for 1–30 users, $11 for 31–99 and $8 for 100+, or from $6.7 with a 12-month commitment. Report viewers are free, and there is a 30-day free trial on Microsoft AppSource.

Bring master data into Power BI.

Clean, validated, governed, and maintained by the business. Try accoMASTERDATA free for 30 days on Microsoft AppSource.