Monday, November 24, 2025
HomeBusiness IntelligenceMicrosoft Material: Automating Material Capability Scaling with Azure Logic Apps

Microsoft Material: Automating Material Capability Scaling with Azure Logic Apps


In a earlier submit I defined the best way to handle the capability prices of a Material F capability (below Pay-As-You-Go pricing mannequin) utilizing Logic Apps to Droop and Resume it.

A buyer who learn my earlier weblog requested me “Can we use an analogous methodology to scale up and down earlier than and after particular workloads?”. This weblog submit is to reply precisely that.

I wish to make some essential factors clear first and earlier than we dig deeper into the answer:

  • The strategy described on this submit works with Material F SKUs below Pay-As-You-Go pricing mannequin.
  • In case you have a Energy BI Premium capability, then this methodology isn’t legitimate to your case. However you is likely to be within the autoscale choice for Energy BI Premium capacities.
  • Relying in your present workload, cutting down could not work because of useful resource unavailability.
  • Relying in your workload, this methodology could take some time to undergo.
  • You might want to be both a Capability Admin or a Material Admin to efficiently implement this methodology.
  • This methodology works primarily based on consumer authentication, nonetheless, it’s possible you’ll wish to use Service Principal or Handle Identification which require extra effort however could possibly be a extra fascinating methodology in lots of situations.
  • This submit explains a really primary situation, you’re welcome to scale it to your particular wants.
  • You possibly can take into account this submit as a continuation of the earlier submit. So in case you are uncertain you accurately perceive what this weblog is making an attempt to elucidate, then I counsel you learn my earlier submit first the place I clarify the Logic Apps implementation in additional element.

I’ve an F Material capability and I wish to upscale it to an higher tier between the pick-time from 8 AM to 12 PM native time, then downscale it to its authentic tier.

There are lots of methods to do that together with utilizing Azure Useful resource Supervisor APIs, Handle Azure Sources in PowerShell, or utilizing Azure Useful resource Supervisor connector that can be utilized on Azure Logic Apps, Energy Automate Premium, and Energy Apps Premium. This submit explores using Azure Useful resource Supervisor connectors in Azure Logic Apps. With that, let’s start.

  1. On Azure Portal, seek for Logic apps
  2. Choose the Logic Apps service
Select Azure Logic Apps on Azure Portal
Choose Azure Logic Apps on the Azure Portal
  1. Click on the Add button
  2. Choose a Subscription from the listing
  3. Choose a Useful resource Group from the listing or create a brand new one
  4. Enter the Logic App title
  5. Choose the Area from the listing
  6. Choose No if you don’t require to Allow log analytics
  7. Choose Consumption from the Plan kind
  8. Click on the Evaluate + create button
Create new Logic Apps service on Azure Portal
Create new Logic Apps service on Azure Portal
  1. Click on the Create button
Confirm creating new Logic Apps service
Verify creating new Logic Apps service

  1. Navigate to the newly created Logic App and click on the Edit button
  2. Choose the Recurrence set off
Use a Recurrence trigger on Azure Logic Apps
Use a Recurrence set off on Azure Logic Apps
  1. Set the Interval to 1 Hour
  2. Add each Time zone and Begin time parameters and set the specified values
Configure the Recurrence trigger
Configure the Recurrence set off
  1. Add a Situation motion below the Management operation and use the next expression to verify if the time is between 8 AM and 12 PM:

int(formatDateTime(convertFromUtc(utcNow(), 'New Zealand Customary Time'), 'HH'))

Use Condition Action on Azure Logic App
Use Situation Motion on Azure Logic App
  1. On the True aspect of the situation, add a Create or replace a useful resource motion which could possibly be discovered by trying to find Azure useful resource supervisor operation
  2. After passing your credentials and signing in choose the Subscription from the listing
  3. Choose the Useful resource Group from the listing
  4. Choose the Microsoft.Material from the Useful resource Supplier listing
  5. Enter capacities/your_capacity_name on the Quick Useful resource Id (substitute the “your_capacity_name” together with your precise capability title)
  6. Enter 2023-11-01 on the Shopper Api Model
  7. Add the Location and SKU Identify parameters, then choose the situation of your capability and enter the specified SKU you wish to upscale
Use "Create or update a resource" action from "Azure resource manager" operation to upscale Fabric capacity SKU
Use “Create or replace a useful resource” motion from “Azure useful resource supervisor” operation to upscale Material capability SKU
  1. Repeat the steps from quantity 18 and add one other Create or replace a useful resource for the False aspect of the situation to downscale the SKU and save the answer
Use "Create or update a resource" action from "Azure resource manager" operation to downscale Fabric capacity SKU
Use “Create or replace a useful resource” motion from “Azure useful resource supervisor” operation to downscale Material capability SKU

The complete workflow should appear to be the next picture:

Scaling Fabric Capacity with Logic Apps
Scaling Material Capability with Logic Apps

That’s it. The workflow will mechanically run each hour and upscale the Material capability to an F8 SKU if the time is between 8 AM and 12 PM, in any other case it ensures that the capability SKU stays at F2 SKU.

Observe

This Logic App efficiently works solely when the Material capability is working. So if the capability is suspended, then the movement will fail with the BadRequest, Service isn’t able to be up to date error. The explanation for that’s the Create or replace a useful resource motion from the Azure useful resource supervisor operation makes use of a PUT API methodology which requires the Material capability to be working.

This weblog submit provides step-by-step steerage on automating the scaling of Microsoft Material F capability utilizing Azure Logic Apps and the Azure Useful resource Supervisor connector. I attempted to additionally spotlight essential issues and limitations.

As at all times, I invite you to share your ideas within the feedback under. Comply with me on X aka Twitter and LinkedIn to get notified of my new posts.


Uncover extra from BI Perception

Subscribe to get the newest posts despatched to your e-mail.



RELATED ARTICLES

Most Popular

Recent Comments