Forum Discussion
Automatic page refresh and Scheduled refresh Differences
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!
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 ofreal 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
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.
2 Replies
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 ofreal 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
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.