Power BI semantic model tools for Excel
Tools for the people who look after Power BI: model owners, BI developers and administrators. Semantic Model Manager is in development. Security, measure, documentation and deployment tools are planned.
Power BI Tools roadmap
Semantic Model Manager
Model upkeep from Excel
Work with published Power BI semantic models from Excel: review and edit measures, relationships and table data, then deploy the changes.
RLS Manager
Row-level security
See every row-level security role and rule in one sheet, edit them in bulk and test what a given user would see.
OLS Manager
Object-level security
Control which tables and columns each role can see, laid out as a permission grid.
Data Dictionary Generator
Model documentation
Produce documentation for a model: tables, columns, relationships and measure definitions, exported to Excel or Word.
Measure Manager
DAX measures
Organize, edit and document measures at scale, and find ones no report uses.
Deployment Manager
Dev, test and production
Compare models across workspaces and promote selected changes from development to production.
Refresh Manager
Refresh monitoring
See refresh schedules and failures across workspaces in one place.
Usage Analytics Manager
Adoption
Bring report usage into Excel to find unused reports and see who relies on what.
Workspace Manager
Governance
List workspaces, their content and permissions, and make bulk permission changes.
Calculation Group Manager
Calculation groups
Create and maintain calculation groups from templates.
Relationship Manager
Model relationships
Review relationships, cardinality and filter direction, and spot common modelling issues.
Who these tools are for
BI administrators
Keep track of workspaces, permissions, refreshes and usage across the organization.
Model owners and developers
Change measures, relationships and reference tables without rebuilding and republishing the whole model.
Security reviewers
See who can access which rows, tables and columns, and document it for audits.
Optalytic, the firm behind BridgeStack, also offers Power BI consulting.
Help shape our Power BI tools
If your team maintains Power BI models, we would like to hear what slows you down. Book a call to talk about Semantic Model Manager and early access.