topic Re: I want to automatically update the report to the latest state at 1-minute intervals. in Report Server

I want to automatically update the report to the latest state at 1-minute intervals.

yyjp — Mon, 30 Sep 2024 02:12:49 GMT

I would like to automatically "refresh" a specific report at 1-minute intervals.
Is there a way to configure something on the server side to achieve this?

(Not client-side JavaScript, etc.)

Re: I want to automatically update the report to the latest state at 1-minute intervals.

lbendlin — Mon, 30 Sep 2024 12:04:00 GMT

Please confirm that this is for Report Server, annd not for Power BI Service.

Consider using APR. https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

Make sure your admins are ok with the frequency.

Re: I want to automatically update the report to the latest state at 1-minute intervals.

yyjp — Tue, 01 Oct 2024 00:26:23 GMT

Thank you for your reply.

I am aware of the following.

- Possible with Power BI Desktop
- Possible with Power BI Service (dashboard)
- Possible with JavaScript in Power BI Report Server client browser (implementation as below)
https://chromewebstore.google.com/detail/power-bi-rs-refresh/ofdbpkdfpkbdeehllfmpafeofnbcjnal

Is there a way to configure it on the server side of Power BI Report Server?

Re: I want to automatically update the report to the latest state at 1-minute intervals.

Anonymous — Tue, 01 Oct 2024 02:40:58 GMT

Thank you lbendlin

Hi, yyjp

You can configure it in the Report server web portal. Here are the specific steps:

With the above steps, your report will be updated every minute to get the latest data. Here are my test results:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: I want to automatically update the report to the latest state at 1-minute intervals.

yyjp — Tue, 01 Oct 2024 06:24:39 GMT

thank you.

I confirmed.

Is it possible to automatically update the report web page?

Re: I want to automatically update the report to the latest state at 1-minute intervals.

Anonymous — Tue, 01 Oct 2024 07:55:54 GMT

Hi, yyjp

Power BI Report Server currently does not provide automatic page refresh. You can refresh the page by pressing F5 on the keyboard or using a browser plug-in.

Compare Power BI Report Server and the Power BI service - Power BI | Microsoft Learn

Since a scheduled refresh is configured every minute, you only need to trigger the page refresh manually or through a Javascript script.

You can set up a page auto-reload in the F12 console using the following Javascript script:

setTimeout(() => { document.location.reload(); }, 3000);

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: I want to automatically update the report to the latest state at 1-minute intervals.

yyjp — Wed, 02 Oct 2024 02:49:16 GMT

thank you.

I checked the browser plugin JavaScript method.

Is there a way to configure equivalent content on the Report Server side?
(So that there is no need to distribute browser plug-ins internally)

Re: I want to automatically update the report to the latest state at 1-minute intervals.

Anonymous — Fri, 04 Oct 2024 03:35:58 GMT

Hi, yyjp

Power BI Report Server itself does not support direct configuration of this page refresh. If you need to implement it, then you may need to involve re-modifying the underlying website building of Report Server and insert the plugin or script you want to distribute there.
I don't think it is an easy way to implement it. The best way is to set up a scheduled refresh and then install some browser extensions for your users to implement the page refresh.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: I want to automatically update the report to the latest state at 1-minute intervals.

miwundu — Thu, 10 Oct 2024 16:41:15 GMT

I think you can click on the grey area on the report builder and then look at the report properties under other. You will see auto refresh. set the time frame you want but be mindful of the size of data or report.

Re: I want to automatically update the report to the latest state at 1-minute intervals.

yyjp — Fri, 11 Oct 2024 00:12:11 GMT

thank you.

Which of the following is a report builder?

・Power BI report builder
・Microsoft Report Builder

Thank you for your support.

Re: I want to automatically update the report to the latest state at 1-minute intervals.

Anonymous — Fri, 11 Oct 2024 02:37:10 GMT

Thank you miwundu

Hi, yyjp

Power BI Report builder is mainly used to publish paged reports to Power BI service.Microsoft report builder is mainly used to publish reports to Report Server. Both report builders can be used to create paged reports.
The refresh time mentioned by miwundu user is one of the features of paged reports, you can enable it from the following figure:

Power BI Paginated Reports June 2019 Feature Update Summary | Microsoft Power BI Blog | Microsoft Power BI

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: I want to automatically update the report to the latest state at 1-minute intervals.

miwundu — Fri, 11 Oct 2024 14:35:41 GMT

Use Microsoft Report Builder.

Click on the Grey area with arrow and then set the auto refresh.

Re: I want to automatically update the report to the latest state at 1-minute intervals.

yyjp — Tue, 19 Nov 2024 00:47:34 GMT

thank you.

I tried using Microsoft Report Builder, but
Can I view reports (.pbix files) created with Power BI?

Re: I want to automatically update the report to the latest state at 1-minute intervals.

miwundu — Tue, 03 Dec 2024 19:56:46 GMT

The Report Builder is different from Power BI Desktop from where you generate the PBIX file. Both are report developing tools/Applications use for report development.