Schedule Refresh is not working after Upgrading version of power BI report server May 2021

[rakeshmistry212]

Schedule Refresh is not working after Upgrading version of power BI report server May 2021 on premises.

It shows refresing status continuously.

Find the attached screen shot

Can help somebudy.

[iponomarev]

in Database engine trace 

exec AddSubscriptionHistoryEntry @SubscriptionID='D534C87E-29A1-45DF-A12A-8B1C2DAB8B6B',@Type=0,@StartTime='2021-08-12 15:52:52.147',@Status=1,@Message=N'Started Data Refresh'

exec UpdateSubscriptionHistoryEntry @SubscriptionHistoryID=0,@EndTime='2021-08-12 15:52:52.147',@Status=2,@Message=N'Data refresh failed. Please try again later or contact your administrator.',@Details=N'{"SessionID":null,"Errors":[{"ErrorCode":0,"Message":"One or more errors occurred.","CallStack":"   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)\r\n   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.ProcessDataRefreshEvent()"}]}'

[rakeshmistry212]

In our case old as well as for newly create chedule both are not working after upgrading of May 2021 Power Bi report server.

[rakeshmistry212]

We check On the PBIRS server machine & open PBIX file and refresh manually that works but schedule refresh on Power BI report Server still not work. It showing refreshing status.

[iponomarev]

we have the same problem 

in RSPowerBI*.log 

2021-08-11 17:02:35.3984|INFO|47|Handling event with data: TimeEntered: 05.08.2021 16:20:02, Type: Event, SessionId: 8450bb74-60d5-4b8b-a844-423fc664a500, EventType: DataModelRefresh
2021-08-11 17:02:45.4125|INFO|102|Handling event with data: TimeEntered: 05.08.2021 16:20:02, Type: Event, SessionId: b2d4a3ea-731b-4c3e-8b63-3416a7b44e5e, EventType: DataModelRefresh
2021-08-11 17:02:55.4227|INFO|92|Handling event with data: TimeEntered: 05.08.2021 16:20:02, Type: Event, SessionId: 2efa75a0-40f7-4958-919a-9b5f2b504274, EventType: DataModelRefresh
2021-08-11 17:03:05.4245|INFO|109|Handling event with data: TimeEntered: 05.08.2021 16:20:02, Type: Event, SessionId: 86e31308-b84d-42f7-8651-50951458b52d, EventType: DataModelRefresh
2021-08-11 17:03:15.4343|INFO|81|Handling event with data: TimeEntered: 05.08.2021 16:20:02, Type: Event, SessionId: a4b3b7db-18ed-4d57-a155-c3e3af14e85c, EventType: DataModelRefresh
2021-08-11 17:03:25.4554|INFO|132|Handling event with data: TimeEntered: 05.08.2021 16:20:02, Type: Event, SessionId: d0618b7e-a355-4e1b-825a-84c00b42de3f, EventType: DataModelRefresh
2021-08-11 17:03:35.4686|INFO|44|Handling event with data: TimeEntered: 05.08.2021 16:20:02, Type: Event, SessionId: 138838d5-c06d-42f9-95d7-311a6260a858, EventType: DataModelRefresh
2021-08-11 17:03:45.4733|INFO|13|Handling event with data: TimeEntered: 05.08.2021 16:20:02, Type: Event, SessionId: b23b2989-affb-4a7e-aab7-68df174b8db0, EventType: DataModelRefresh

 but no next steps or errors

[FarhanAhmed]

Kindly check the logs whether the schedule is running or not?

Also, check the connectivity(Bandwidth) between the PBIRS machine and the data sources.

[rakeshmistry212]

We cheked the connectivity(Bandwidth) between the PBIRS machine and the data sources are same server & it is working ok. still Schedule Refresh is not working.

[FarhanAhmed]

On the PBIRS server machine try to open your PBIX file and refresh manually that file and see if this is working properly as desired, if not refreshing try to limit which data source having this problem.

[iponomarev]

If topicstarter has a similar problem, then problem concerns only new schedule. For example if i change time interval for old schedule (or create new) - it not refreshing (refresing status continuously). But before change (or old schedule) it work good. 

[rakeshmistry212]

In our case old schedule or while creating new schedule both scenario schedule refresh is not workin after upgrading May 2021 Power Bi report server.