topic Re: Schedule Refresh is not working after Upgrading version of power BI report server May 2021 in Report Server

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

rakeshmistry212 — Wed, 11 Aug 2021 12:00:26 GMT

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.

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

FarhanAhmed — Wed, 11 Aug 2021 12:10:52 GMT

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

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

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

rakeshmistry212 — Wed, 11 Aug 2021 12:27:12 GMT

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.

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

iponomarev — Wed, 11 Aug 2021 14:34:28 GMT

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

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

FarhanAhmed — Thu, 12 Aug 2021 04:14:11 GMT

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.

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

rakeshmistry212 — Thu, 12 Aug 2021 04:18:24 GMT

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.

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

iponomarev — Thu, 12 Aug 2021 08:11:12 GMT

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.

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

rakeshmistry212 — Thu, 12 Aug 2021 10:43:26 GMT

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

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

iponomarev — Thu, 12 Aug 2021 12:57:14 GMT

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()"}]}'

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

rakeshmistry212 — Tue, 17 Aug 2021 03:40:01 GMT

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.