Power BI Administration

1. Proper Job Description

Technical Skills:

Power BI administration

• Manage and troubleshoot Power BI Gateway and Report Server issues from an administrative perspective.

• Perform fabric capacity planning to optimize resource utilization. FUAM and Fabric Capacity complete understanding.

• Administer Power BI Gateway Server, Report Server, and SSRS environments.

• Manage Power BI Data Gateway Clusters, user access, data connections, and configurations.

• Develop monitoring solutions and automation scripts to ensure system uptime and health.

• Work on Windows on-premises server platforms for deployment, maintenance, and upgrades.

• Manage Power BI Premium capacities, including workspace and group management in the cloud.

• Install, configure, and maintain Power BI Desktop, Power BI Report Builder, and Power BI Report Server applications.

• Set up data sources and configure drivers for Oracle, SQL Server, DB2, MySQL, and Azure Synapse.

• Expertise in integrating Power BI with Azure and Databricks.

• Develop, test, and enhance Power BI audit reports during maintenance activities.

• Integrate Power BI report server metadata with Collabra and manage SSL certificate renewal processes.

• Create and maintain advanced performance analysis reports for Power BI models, DAX queries, and system metrics.

• Monitor and analyse Gateway metrics to identify performance issues.

• Collaborate on Power BI audit report enhancements and assist with Hyperion to Power BI migration audits.

• Implement Azure Blob Storage solutions for copying Gateway statistics using PowerShell scripts.

• Manage service account configurations and automate offline data source refreshes with Power Automate.

• Perform Power BI Gateway upgrades and apply key configuration changes for system stability.

• Support Power BI report server setup, maintenance, and metadata management.

• Document best practices, troubleshooting procedures, and performance optimization strategies.

• Strong automation expertise using Python and PowerShell scripting is essential.

• Hands on experience in creating ad hoc Power BI reports for audit requirements is required.

Responsibilities:

• Respond to and resolve tickets on technical issues related to Power BI Platform within defined SLA.

• Work closely with users assisting with Power BI issues, training, and building good working relationships.

• Assist user and project support for all BI Systems.

• Creation and maintenance of system documentation related to the Power BI environment.

• Ability to prioritize and work on multiple tasks simultaneously.

• Strong communication and organizational skills.

• Document the issues in knowledgebase entry and train the team to handle the recurring issues.

2. Primary Skills in 5 liners that manager cannot negotiate on –

• Expertise in complete Power BI administration, including workspace, capacity, and gateway management.

• Strong knowledge of tenant settings, security configurations, and governance best practices.

• Hands on experience with Power BI Service, monitoring, auditing, and usage analytics.

• Proficiency in managing data refreshes, gateways, deployments, and workspace lifecycle.

• Ability to enforce compliance, optimize performance, and support enterprise level Power BI environments.