difference between Page Refresh and a normal refresh

[AliSafa]

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 license?

I mean if both options refresh the data, why would we be limited to only 48 times?

why not choose the Page refresh option to be refreshed every 5 seconds instead?!

thank you

[Greg_Deckler]

@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]

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?

[Greg_Deckler]

@AliSafa Correct.

[AliSafa]

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