cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
murater85
Frequent Visitor

Power Bi Reports Refresh Problem with May 2020 Updated Version

Hi,

We upgraded our Power BI Report Server last week to May 2020 update. We noticed that edited and saved reports not refresh at Power Bi Server but scheduled task refresh without any problem.

How can we solve this issue? maybe it is bug for May 2020 update is there any workarround about May 2020 update2 ?

 

Thanks.

9 REPLIES 9
josef78
Impactful Individual
Impactful Individual
bradsy
Microsoft
Microsoft

This is a bug in the current release. The team is working on a fix, going through testing and should be released once validated. Later this week or early next week of no issues.

josef78
Impactful Individual
Impactful Individual

@bradsy please, any news when new version will be published?

josef78
Impactful Individual
Impactful Individual

Bad news! :(((((

There is new version published (15.0.1103.232), but this version not solving this issue completely. This version solving refresh cache only in case of manual upload from PBID.

In case of scheduled refresh (in case when data refresh is processed on another server than frontend server in scale-out deployment) is still not solved. After data datarefresh data in SSAS cache are not retried on all servers and using cached out-of-date data.

 

This issue, after two weeks is still not resolved.

Thanks josef78 - We will look into this ASAP.

 

Also, can you provide exact repro steps?

josef78
Impactful Individual
Impactful Individual

@bradsy thanks. 

OK:

Power BI Report Server farm with minimum two app servers (not including server with MSSQL hosting ReportServer DB), on both is installed PBIRS May2020 15.0.1103.227 or 232, servers are joined to scale-out deployment, first server is used as web front-end (users are connecting thru DNS alias to this server via browser) and this server is not used for processing datarefreshs ( <IsDataModelRefreshService>False</IsDataModelRefreshService> in rsreportserver.config). Second server is configured for background data refresh processing (<IsDataModelRefreshService>True</IsDataModelRefreshService> in rsreportserver.config). In report server catalog exist least one report with Import mode data (not directquery or Live Connected) and scheduled datarefresh.

 

Repro Steps:

1) Open any report (with import mode data) via browser (on first server is logged actions in order ASModelStream, ConceptualSchema and QueryData) - it's is OK
2) Wait for scheduled datarefresh or run "Refresh Now" from scheduled refresh setting of this report, and check if finished. Second sever will refresh data in model and store in DB (second server logs ASModelStream, DataRefresh and SaveToCatalog)  - it's is OK

3) Reopen this report via browser. Time between step 1) and 3) must be shorter then Model Expiration, by default 60minutes. Report show same data as in step 1), not affected by refresh. (first servers logs only ConceptualSchema and QueryData - there is missing first action "ASModelStream" which reloading data from DB to SSAS cache if is refreshed)

 

josef78
Impactful Individual
Impactful Individual

There is also ExcecutionLog3 for last retest:

 

InstanceName ItemPath RequestType Format ItemAction TimeStart TimeEnd Source Status
SRVRV164\PBIRS /TEST/report1 Interactive PBIX ASModelStream 2020-06-16 12:03:07.230 2020-06-16 12:03:10.130 Cache rsSuccess
SRVRV164\PBIRS /TEST/report1 Interactive PBIX ConceptualSchema 2020-06-16 12:03:11.773 2020-06-16 12:03:13.853 Cache rsSuccess
SRVRV164\PBIRS /TEST/report1 Interactive PBIX QueryData 2020-06-16 12:03:13.993 2020-06-16 12:03:16.920 Cache rsSuccess

 

SRVRV231\PBIRS /TEST/report1 Refresh Cache DataModel ASModelStream 2020-06-16 12:04:07.697 2020-06-16 12:04:10.533 Live rsSuccess
SRVRV231\PBIRS /TEST/report1 Refresh Cache DataModel DataRefresh 2020-06-16 12:04:10.550 2020-06-16 12:04:25.633 Live rsSuccess
SRVRV231\PBIRS /TEST/report1 Refresh Cache DataModel SaveToCatalog 2020-06-16 12:04:25.777 2020-06-16 12:04:26.437 Live rsSuccess

 

SRVRV164\PBIRS /TEST/report1 Interactive PBIX ConceptualSchema 2020-06-16 12:05:13.053 2020-06-16 12:05:13.130 Cache rsSuccess
SRVRV164\PBIRS /TEST/report1 Interactive PBIX QueryData 2020-06-16 12:05:14.070 2020-06-16 12:05:14.197 Cache rsSuccess

 

It's mean, Query from cache at 12:05:xx is from same cache as is at 12:03:xx. Datarefresh at 12:04:xx not update cache on any server, and cache NEVER expire with out-of-date data. Only possible way how force refresh cache is restart server.

 

Hi,

Is there any news update v2 for refresh problems with May 2020 update?

 

I check blog and community but I can not see yet.

 

thanks.

josef78
Impactful Individual
Impactful Individual

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors