Power BI Administrator

Desired Experience Range Strong hands-on experience in Power BI administration and production support.

Expertise in workspace management, data gateways, semantic models, datasets, reports, and dashboards.

Experience in troubleshooting dataset refresh failures, gateway issues, and report performance problems.

Desired Competencies (Technical / Behavioral Competency)

Must-Have:

Power BI Administration

Power BI Tenant Administration

Workspace Management & Governance

Power BI Service Administration

Dataset & Semantic Model Management

Dashboard & Report Administration

Power BI Premium Capacity Management

Monitoring & Support

On-Premises Data Gateway Administration

Dataset Refresh Monitoring & Troubleshooting

Power BI Tenant Health Monitoring

Capacity Utilization Monitoring

Incident & Problem Management

Service Performance Monitoring

Security & Governance

Row-Level Security (RLS)

Workspace Security Administration

Access Management & Auditing

Governance Policy Enforcement

Compliance & Risk Management

Reporting & Analytics

Power BI Reporting Support

DAX Troubleshooting

Query Performance Analysis

Report Optimization

BI Service Reporting & KPI Tracking

Good-to-Have:

Microsoft Fabric Administration

Azure Data Services

Azure Active Directory / Entra ID

SQL Server Administration

PowerShell Automation

Azure DevOps

Data Warehouse Concepts

ETL/ELT Processes

Power Apps & Power Automate

Monitoring Tools (Splunk, Dynatrace, AppDynamics)

Responsibility of / Expectations from the Role

1. Power BI Platform Operations:

Provide end-to-end administration and operational support for the enterprise Power BI tenant.

Manage workspace provisioning, role assignments, governance compliance, and decommissioning activities.

Monitor tenant health, workspaces, datasets, semantic models, reports, and dashboards.

Administer and support On-Premises Data Gateways as per enterprise architecture standards.

2. Monitoring & Troubleshooting:

Investigate and resolve dataset refresh failures and gateway-related issues.

Perform trend analysis to proactively address recurring platform problems.

Monitor Premium Capacity utilization and identify optimization opportunities.

Lead incident management activities for critical platform issues.

3. Security & Governance:

Implement and maintain Row-Level Security (RLS) policies.

Conduct periodic access reviews and compliance audits.

Ensure alignment with organizational governance standards and security policies.

Support audit, regulatory, and compliance requirements.

4. Performance Optimization:

Analyze report and dataset performance bottlenecks.

Recommend query optimization, dataset compression, and capacity balancing improvements.

Drive platform efficiency and service reliability initiatives.