In this video, I walk you through the steps required to automate the scaling of Microsoft Fabric capacities using Azure LogicApps. If you have watched my previous videos, you know that I have published solutions to "Pause" and "Resume" Fabric capacities to manage costs effectively. Today, I will explain a new scenario where you can scale the capacity up and down within a specific time frame during the day.
If you've encountered any capacity admin permission issues while setting up automation, this video will guide you through the solution, ensuring a smooth process for managing your Microsoft Fabric capacities.
For more detailed information, I have published a corresponding blog post that covers this topic in-depth. You can read it here: Microsoft Fabric - Resolving Capacity Admin Permission Issues in Automate Capacity Scaling with Azure LogicApps: https://biinsight.com/microsoft-fabric-resolving-capacity-admin-permission-issues-in-automate-capacity-scaling-with-azure-logicapps/
Purchase my book, "Expert Data Modeling with Power BI, 2nd Edition" from here: https://amzn.to/437WI1L
Visit my blog: https://biinsight.com/
Follow me on LinkedIn: www.linkedin.com/in/bakhshi
X (Twitter): https://x.com/_SoheilBakhshi
Don't forget to like, share, and subscribe for more insights on #PowerBI and #MicrosoftFabric!
Workflow Definition Language expressions used in this solution:
Trigger expressions:
Run trigger on weekdays:
@contains(
'12345',
string(
dayOfWeek(
convertFromUtc(
utcNow(),
'New Zealand Standard Time'
)
)
)
)
Run trigger on certain timeframes in the day:
@and(
greaterOrEquals(
int(
formatDateTime(
convertFromUtc(
utcNow(),
'New Zealand Standard Time'
),
'HH'
)
),
12
),
less(
int(
formatDateTime(
convertFromUtc(
utcNow(),
'New Zealand Standard Time'
),
'HH'
)
),
17
)
)
The following expression provides an array of members from the "Read a resource" operation's admins:
body('Read_a_resource')?['properties']?['administration']?['members']
Chapters:
00:00 - Channel trailer
00:19 - Introduction
02:13 - Create a new Logic Apps Workflow
03:03 - Solution Implementation
09:47 - Demonstrating Issues
10:35 - Troubleshooting
11:17 - Resolving the Issue
13:50 - Testing the Fix
15:23 - Moment of Truth
16:02 - Wrap up
Songs: Moth; Beyond The Dust
Music by: CreatorMix.com