Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
lawrenceabith
Helper IV
Helper IV

How to schedule to scale a Fabric capacity via script? Like we have in Power BI embedded?

Dear sirs,

 

I need to change the Azure fabric capability size to F64 every night for one hour to refresh my reports because with F8 I am receiving a memory error. Do you know how to do that via script to schedule an automatic job? 

 

I used to do that with Power BI embedded.

 

I appreciate it a lot with anybody who knows how to do it. I've tried everything.

 

lawrenceabith_0-1690204421758.png

 

 

Thanks a lot!!

5 REPLIES 5
manu_exl
New Member

I took a different approach to implement this for a client.

A Databricks notebook which makes API calls to Pause/Resume is scheduled as a simple job. The notebook has logic written to Pause if its beyond end of the day 6PM and same notebook when run during office time will resume the capacity. Scheduling it twice is the easiest part, executes the notebook using a very cheap serverless job in <2mins.

The reason we chose Databricks notebook over LogicApp was that these notebooks can be easily adapted to Fabric notebook when a separate production Fabric Capacity which is expected to run 24X7.

lawrenceabith
Helper IV
Helper IV

Hey, community!

 

I realize that we can do this using the Power Automate or Logic App from Azure, we can invoke resource operations. I try with the configurations below but I don't know where I find the documentation about the Microsoft Fabric capacity API. 

 

lawrenceabith_0-1706032032238.png

Does anybody know this? Can you help me?


Thanks a lot!
Lawrence Teixeira

lawrenceabith
Helper IV
Helper IV

Does anybody have news about this? 

 

Thanks a lot!

lawrenceabith
Helper IV
Helper IV

I need to revert to Power BI embedded since we're currently handling this task manually every day. I inquired about a solution two months back, but haven't received a response. Am I correct in understanding that it's not feasible?

Martin_D
Super User
Super User

Looking for the same.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.