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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

AliSafa Page refresh just refreshes the visuals on the page from the current data. Normal refresh actually refreshes the data from the source systems. Page refresh does not refresh the data from the source systems.

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!!