Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
2 years ago

refresh for live report

let say if i need to click on refresh button on internet browser to show latest data on report then can we consider that report as live?

 

example, in case of ssrs report connected with sharepoint live , we need to click on refresh button to show the latest data on ssrs report . the data in ssrs report get updated in fraction of seconds however i still need to click on refresh button to show the latest data.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, powerbiexpert22 

     

    According to your description, in the context of Power BI and similar reporting tools, a "live report" typically refers to a report that uses either a Live Connection or DirectQuery to access and display data. These methods allow the report to reflect current data without the need for manual data refreshes because they query the data directly from the source in real-time.
    Related link: On-premises data gateway sizing - Power BI | Microsoft Learn

    However, for SSRS reports, especially when connected to SharePoint, the behavior can be slightly different. While the data within the report might be updated in real-time or near real-time, the display of that data in a web browser might not automatically refresh to show the latest data without some user interaction, such as clicking the refresh button. This is because the report rendering in the browser does not automatically query for new data unless instructed to do so.

     

    To address your question directly: While the underlying data for the report may be "live" in the sense that it is updated in real-time, the requirement to manually refresh the browser to see the latest data means the report presentation is not fully "live" in the way we might expect with direct live connections in Power BI.

     

    For a truly "live" experience where the report automatically updates without manual intervention, you might explore options such as:

    1. Implementing Auto-Refresh in the Web Page, some custom HTML or JavaScript can be used to automatically refresh the page at set intervals. However, this is more of a workaround and might not be suitable for all scenarios.
    2. Exploring Power BI Options, if using Power BI, consider push datasets or streaming datasets for real-time data updates without manual refreshes.

    Related link: Move Power BI between regions - Power BI | Microsoft Learn

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum