Add time interval between two refreshes and Applied Steps

Assuming your report is hosted in Premium workspace, you can use the REST API to partially refresh the table, add a wait time of 30 secs post that trigger another table partail refresh.

https://learn.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh

Hi hyaa,

 

Thank you for reaching out to the Microsoft Fabric Community Forum.

 

We sincerely apologize for the inconvenience. After reviewing the issue of add time interval between two refreshes and applied steps, here are some steps that might help resolve the issue:

 

Function.InvokeAfter can introduce a delay, but Power Query does not have a built in sleep or pause function.

 

• Function.InvokeAfter can be used to introduce a delay between steps in Power Query. This function allows you to specify a delay before invoking a function, which can help avoid API rate limits by waiting for a specified duration before proceeding to the next step. Function.InvokeAfter - PowerQuery M | Microsoft Learn

• The wait-retry pattern involves waiting for a specified time before retrying a query. With each attempt, the wait time doubles, up to a maximum of five retries. This method is effective for managing API rate limits. Using the wait-retry pattern in Power Query connectors - Power Query | Microsoft Learn

• Managing API Rate Limits: To minimize the frequency of requests, consider batching API calls. By grouping multiple items into a single call rather than making individual calls for each item, you can effectively stay within the API rate limits.

If this post helps, please give us Kudos and consider accepting it as a solution to help other members find it more quickly.

 

Thank you.