cancel
Showing results for 
Search instead for 
Did you mean: 
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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.