cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

PBI Server May 2020 not refreshing saved reports

Last week I've updated Report server to version May 2020 (15.0.1103.227). I also updated Power BI Desktop (Optimized for Power BI Report Server - May 2020).

I notices the following issue: When I open the report with Edit in Power Bi Desktop, manually refresh data and change something small in report view, then save on PowerBI Report Server and refresh browser, nothing happens. In column Modified Date I see that the report has been modified, but in the report the data is old, like I never refreshed it.

After I restart the PowerBI Server (Stop then Start) the reports are refreshed.

 

I looks like there is a problem with the cache or something like that. Is there any new option in Power BI Desktop (Optimized for Power BI Report Server - May 2020) regarding this issue?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: PBI Server May 2020 not refreshing saved reports


@ultrashock wrote:

So, the only workaround is to return to Jan 2020 version? 
Is it safety just to install the older version?


So one workaround is open your report in desktop, then go back to the portal and delete the file from there before you save. But that is not great for end users.

 

Otherwise you either have to wait for a fix or look at going back to Jan 2020. Although Ideally you should restore the ReportServer database from a backup as I'm not sure if the May release made any schema changes or not. 

 

Realistically my guess is that it could be at least a week or two, maybe longer before an update is published. Even if they have a fix for this today Microsoft will need to do a full test run to make sure that the fix does not break anything else. The last thing they want to do is rush out a fix that breaks something else.

View solution in original post

54 REPLIES 54
Highlighted
Frequent Visitor

Re: PBI Server May 2020 not refreshing saved reports

I have the same situation. Even, If you select "Edit in Power BI Desktop" you can see refreshed data. But on the Report Server old version report is displayed

Highlighted
Helper III
Helper III

Re: PBI Server May 2020 not refreshing saved reports

Yes, this is exactly what i meant.
I really hope someone to provide explanation and solution for this problem.

Highlighted
Frequent Visitor

Re: PBI Server May 2020 not refreshing saved reports

I'm seeing a similar issue, I can make a small change like a background colour, then save to teh server and the background colour is updated but the data is still showing an earlier version. 

 

I am also getting a sign in dialog almost every time I click on anything in the desktop client. It was never necessary to be signed in to the service in previous versions.

 

 

Highlighted
New Member

Re: PBI Server May 2020 not refreshing saved reports

We have the issue, reports are not refreshing after uploading to PowerBI Report Server. In Modified column I can see that the version is new, but the data in the report is old. Sometimes it works fine, but most of the time the reports are not refreshing. 

 

Highlighted
Super User III
Super User III

Re: PBI Server May 2020 not refreshing saved reports

This definitely looks like a bug. There was a similar issue in the Jan 2020 release where schedule refresh would sometimes load an old copy of the model under certain circumstances. I've raised this with some contacts at Microsoft to see if I can find out what's going on.

 

The issue with multiple signin prompts seems to be triggered by third party visuals. So at the moment the work arounds for that are that you can either roll back to the Jan 2020 desktop version, not use custom visuals, or sign-in. 

Highlighted
Frequent Visitor

Re: PBI Server May 2020 not refreshing saved reports

I also noticed that RLS stopped working. Does anyone have a similar problem?

Highlighted
Super User III
Super User III

Re: PBI Server May 2020 not refreshing saved reports


@Strangers wrote:

I also noticed that RLS stopped working. Does anyone have a similar problem?


I just setup a new file with RLS, deployed it and added myself to a role and it worked fine. What specific issue are you seeing?

Highlighted
Frequent Visitor

Re: PBI Server May 2020 not refreshing saved reports

As with data, this works for newly created reports.
But I added the RLS to the existing report and updated it manually. As well as for the data in the report, there was a certain delay in time (about 1 hour) after which the RLS began to work.

Highlighted
Helper III
Helper III

Re: PBI Server May 2020 not refreshing saved reports

So, the only workaround is to return to Jan 2020 version? 
Is it safety just to install the older version?

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021