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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.