cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gregboothdelt
Helper I
Helper I

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

Hi

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

 

 

pbi.JPG

 

1 ACCEPTED SOLUTION
tsql_simon
Advocate I
Advocate I

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.

View solution in original post

3 REPLIES 3
josef78
Super User
Super User

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)

tsql_simon
Advocate I
Advocate I

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.

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

Thanks!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.