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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
cccarv82
Frequent Visitor

Is there a way to automate my data refresh ? Help please...

Hi! I have my data gathered from an API where i needed to create two functions to be able to get all the data that ai need.

 

I have an function to get the data from the API and then in this results i have a field with a string to get the next page of results. So i have another function to perform the request using the "next_page" value and get the next page of results. In the end i sumarize everything into a list and then i have a table with all results sumarized.

 

My function where i use the "next_field" value to perform the next page requests receive an parameter with this value.

 

function to generate the list:

 

= List.Generate(
	() => [offset = 0, listQtd = getItemNextPage("/api/v3/search/stories?query=created%3A2022-01-01..*+is%3Astory&page_size=25")],
	each [offset] <= 727/25,
	each [offset = [offset] + 1, listQtd = getItemNextPage([listQtd][next])]

)

 

 

function getItemNextPage where i use the "next_page" value

 

= (page as text) =>
let
    Fonte = Json.Document(Web.Contents("https://api.something.com"&page, [Headers=[#"Content-Type"="application/json", #"Some-Token"="123-456"]]))

in
    Fonte

 

 

Ok... so now i have my table populated with all the results that i need but i`m unable to schedule the update of that table...

 

I get this:

cccarv82_0-1651679263013.png

 

So is there a way to schedule this update ???

 

 

 

1 REPLY 1
v-chenwuz-msft
Community Support
Community Support

Hi @cccarv82 ,

 

I don't think it's possible to do that. Maybe you can try python script to do that. And only personal gateway support python script refresh.

 


Best Regards

Community Support Team _ chenwu zhu

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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