topic Re: KPI does not refresh in Report Server

KPI does not refresh

cnschulz — Mon, 13 May 2019 23:51:14 GMT

Howdy,

We are running Jan 2019 PBIRS

Yesterday, I added a KPI to our PBIRS front page that reports the number of report failures for the day (with trend). This morning the KPI was showing "1" although there were no failures. The corresponding tabular report linked to the same shared dataset shows the correct data. I used VS 2017 to generate toe datasource, dataset and tabular report and published directly from VS to PBIRS.

I then added a second identical KPI and it shows the correct data: "0".

Is this a bug? Do KPI's from shared datasets actually work? Any tips for getting this working?

Re: KPI does not refresh

d_gosbell — Tue, 14 May 2019 05:16:03 GMT

Unfortunately this is "by design" as we go bitten by this issue too. KPIs always use cached data regardless of that setting on the dataset. The work around is to just setup a scheduled cache refresh. We've just setup a scheduled cache refresh plan that updates the cache every 10 minutes during business hours and it works fine.

Re: KPI does not refresh

cnschulz — Tue, 14 May 2019 05:44:31 GMT

Cheers,

Hmmm, this seems *crazy*. I have a paginated report hanging off that same dataset and it refreshes on-demand. I dont have control of cache settings in the KPI tile, so therefore I would have to change the behaviour of the dataset to be cached therefore changing the report to a cached model regardless of the report setting.

Is there a way for me to (from a single dataset) have the KPI operate from caced data as advised, and the report continue to operate in on-demand mode?

Thanks for your help.

d_gosbell wrote:
Unfortunately this is "by design" as we go bitten by this issue too. KPIs always use cached data regardless of that setting on the dataset. The work around is to just setup a scheduled cache refresh. We've just setup a scheduled cache refresh plan that updates the cache every 10 minutes during business hours and it works fine.

Re: KPI does not refresh

LeonLDZG — Thu, 03 Nov 2022 07:35:56 GMT

Did you eventually solve this problem?

Re: KPI does not refresh

LeonLDZG — Thu, 10 Nov 2022 07:54:44 GMT

I found out that you always would need a cache with schedule on it for it to refresh