topic Re: Is a Manual refresh of a report on power bi report server possible ? in Report Server

Is a Manual refresh of a report on power bi report server possible ?

gregboothdelt — Tue, 26 Oct 2021 11:23:13 GMT

We are about to go live with an on premise power bi report server - i.e. on our network

When a user goes to the web portal - and browses to a folder containing reports - like

https://servername.domain.local/ReportsPBI/powerbi/folder1

then they see the report etc.

At the top - their are some options - File, View, Edit in Power Bi Desktop, Explore Refresh.

What does the refresh buton actually do ? i.e. will hitting the Refresh option do a manual refresh of the data in the report?

If not is there a way for the end user to force a refresh of the data in the report (from their web browser?)

Thanks

Re: Is a Manual refresh of a report on power bi report server possible ?

tsql_simon — Tue, 26 Oct 2021 12:56:33 GMT

Hi,

It refreshes the Visuals on the report based on the data, so if it is a direct query the visuals updated with latest data, if a scheduled data refresh (Import query) has occured since the page was loaded it will refresh and visuals updated with latest data else it does not do anything.

Re: Is a Manual refresh of a report on power bi report server possible ?

josef78 — Thu, 28 Oct 2021 19:25:27 GMT

Generally refresh data for all visuals in report.

But, it depens on report type and server configuration:

-If it is DirectQuery PBI report, it refresh data from DB source (which can be changed anytime, or not)

-If it is Live Connected (to SSAS) PBI report, it refresh data from SSAS database (which can be procesed meantime, or not)

-If it is Import mode PBI report, and you have single server configuration, it refresh data from SSAS cache (which can be refreshed meantime by scheduled refresh, or not)

-If it is Import mode PBI report, and you have scaled-out configuration, it does nothing (it is probably bug)

Re: Is a Manual refresh of a report on power bi report server possible ?

gregboothdelt — Thu, 28 Oct 2021 22:16:29 GMT

This seems to agree with what we have found with our testing.

Thanks!