Automatic page refresh and Scheduled refresh Differences

[mit1]

Hi all, pardon me for my newbie question.

May I clarify what is the difference between automatic page refresh (APR) and scheduled refresh (SR)? From what I understand, APR is only used in DirectQuery. I'm not sure if both refreshes work the same way.

My goal is to create a dashboard for my customers that refreshes every 5 mins with the latest data, which way should I go with (or any other ways you'd recommend)?

Thanks!

[Ritaf1983 · Accepted solution]

Hi @mit1 
Schedule refresh is limited to 8 times a day with pro capacity and 48 times in premium so it can't meet a goal of 5 minutes intervals.
So you need to use direct query or
check the option of 

real time streaming dataset or push dataset(manually push new records to dataset), they were more quickly than a scheduled refresh.

Reference links:

Real-time streaming in Power BI 

Push data into a Power BI dataset 

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

[Idrissshatila · Accepted solution]

Hello @mit1 ,

if your goal is to create a dashboard that refreshes every 5 min, then you need to use the direct query mode and set the automatic page refresh to 5 min. This won't work with import mode.

[Ritaf1983 · Accepted solution]

Hi @mit1 
Schedule refresh is limited to 8 times a day with pro capacity and 48 times in premium so it can't meet a goal of 5 minutes intervals.
So you need to use direct query or
check the option of 

real time streaming dataset or push dataset(manually push new records to dataset), they were more quickly than a scheduled refresh.

Reference links:

Real-time streaming in Power BI 

Push data into a Power BI dataset 

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