Microsoft Fabric Capacity Made EASY To Understand!

    In this informative session, Manuel Quintana from Pragmatic Works breaks down the complexities of Microsoft Fabric capacity licensing. The video is designed to help organizations understand their options, evaluate cost implications, and learn how to provision and manage Fabric capacities effectively.

🔍 Why Start with a Fabric Trial?

• Microsoft offers a 60-day free trial of Fabric, typically mimicking an F64 SKU.
• Ideal for proof-of-concept testing to determine if Fabric suits your organization’s needs.
• Trial usage helps assess whether you need more or less capacity before committing financially.

💳 Capacity Licensing Options

There are two main licensing models:

1. Pay-As-You-Go: Flexible and ideal for development environments. You can pause capacity to save costs when not in use.
2. Reserved Pricing: Best for production workloads. Offers predictable pricing and performance with significant cost savings over time.

📊 Understanding SKUs and Pricing

• Fabric SKUs range from F2 to F2048.
• F64 is a common benchmark, equivalent in performance to a Power BI Premium P1 SKU.
• New customers can no longer purchase P SKUs; they must use F SKUs.
• Pay-as-you-go for F64 costs over $3,000 more per month than reserved pricing if used 24/7.

🛠️ Managing Capacity in Azure

All provisioning and management of Fabric capacities are done through the Azure Portal:

• Search for “Microsoft Fabric” in Azure to create a new capacity.
• Choose subscription, resource group, region, and SKU size.
• Regions should match your Power BI tenant to avoid ingress/egress charges.
• Capacities can be scaled up or down (e.g., F2 to F16) and paused/resumed as needed.

⚙️ Automating Cost Management

Manuel introduces a method to automate capacity management using Azure Data Factory pipelines:

• Set up pipelines to check capacity status and pause them after business hours.
• This prevents unnecessary charges and ensures efficient resource usage.
• Fabric pipelines can’t manage paused capacities, so Azure Data Factory is preferred for automation.

🧠 Final Thoughts

Manuel emphasizes the importance of testing with the trial version before purchasing. Whether you choose pay-as-you-go or reserved pricing, all configurations are handled in Azure. With the right setup and automation, organizations can optimize both performance and cost.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Fabric and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.