Skip to content
All projects

Power BI Architecture Modernization

Migrated the enterprise BI environment from import-model RBAC duplication to Snowflake-backed RBAC with DirectQuery, and designed the on-prem gateway architecture connecting Power BI to the internal data center.

Power BI RBAC Architecture Governance

The problem

Hundreds of Power BI reports, each duplicating access control in import models — a sprawling, fragile RBAC surface.

What I did

  • Re-architected the workspace strategy.
  • Moved from import-model RBAC duplication to Snowflake-backed RBAC with DirectQuery.
  • Designed and rolled out the on-prem gateway architecture from Power BI back to the internal data center.
  • Stood up a Power BI Center of Excellence with governance, access controls, and training.

Result

Eliminated a major class of access-control duplication across hundreds of reports — and cut time-to-insight 60%.