Forum Discussion

AliSafa's avatar
AliSafa
Advocate I
3 years ago

difference between Page Refresh and a normal refresh

Hi Folks,   what is the difference between the option "Page Refresh", which we would have a refresh even every second!!! and the normal refresh that is possible only 48 times per day with a Premium...
Need Help
AliSafa's avatar
AliSafa
Advocate I
3 years ago

thanks Greg, So it means
lets say ,a new row has added to my sql table, so the Page Refresh would not detect it, am i right?
it means that if i really need to refresh the data/values from the source, i can not rely on this Page Refresh option?

  • AliSafa's avatar
    AliSafa
    Advocate I
    3 years ago

    Thanks Greg
    i just did a quick test, i created a table in sql server, and put some values in there, then i set up the page refresh option with interval 2 seconds for my power bi report, direct query to my sql table.
    as soon as i add or modify something in my sql table, i can see that change immidiately effected in power bi report.
    but when i publish it into the workspace, the changes will be shown in about 15 min.

    so i guess power Bi Desktop Page Refresh works good. it would capture the new fresh data and other changes from the source.
    the only issue is: in power bi workspace it takes a little long to be effected.
    so again it makes me more confused about why we dont use this nice option instead of a normal refresh!!