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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ManishML
Frequent Visitor

Hit specific API in a time loop (After defined duration)

Hello, Basically I want to hit some API's instead of whole dashboard as it affects the database. so is it possible to create a loop / function which can hit some API's after a defined time span, like after every hour, or is it possible to create a timer / scheduler of some specific API's to pull data as in result the whole dashboard will be updated on daily basis and some API's on hourly basis.

2 REPLIES 2
ManishML
Frequent Visitor

Firslty, thank you for this informative article, but I am looking for something which could hit my API every hour. so I will be able to analyse hourly data.(Also can't use schedular as it loads the whole dashbored, I just wanted to hit some APIs) Now the reason why I mention word loop in my question is, Any loop / function / timer which in result hit API continuesly for every single hour. 

v-xiaotang
Community Support
Community Support

Hi @ManishML 

Thanks for reaching out to us.

Here is a great article on it, How to loop through an API with Power BI without knowing last page – PBI Guy (pbi-guy.com)

vxiaotang_0-1664525955667.png

...

vxiaotang_1-1664526049623.png

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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