Schedule refresh keep Rerfeshing status

[Anhsang84]

Hi support team,

I met a problem with our Report Server. Last week, I upload one more new Report and found that the schedule refresh did not run and always keep Refreshing status

I try to delete and reupload another report to check and I saw that will all new reports that were uploaded to Server, the schedule refresh met the same problem.

Could you please help us find the root cause and fix it?

Thanks & best regard!

Hi @v-yanjiang-msft ,

Thanks for your reply. Sorry, I could not post the comment (I don't know why) so I have to edit it.

I already did as the instruction at the link https://learn.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot#tools-for-tr...

However, I found the log:

2023-04-11 13:36:18.3949|INFO|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Starting Data Refresh.
2023-04-11 13:36:18.3949|INFO|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Starting Retrieving PBIX AsDatabaseInfo.
2023-04-11 13:36:18.4418|INFO|50|Finding model for refresh sessionId=f1077666-e1e2-4925-a915-251fde0c2753, catalogId=30274bd2-dd80-4410-b667-f836519b34b4, lastCatalogItemUpdate =11/8/2022 8:02:49 AM, lastModelUpdateinCatalog=4/11/2023 1:33:19 PM, resolved to database name=30274bd2-dd80-4410-b667-f836519b34b4_-1186221229, wasInMemory=True
2023-04-11 13:36:18.4418|TRACE|57|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Finished Retrieving PBIX AsDatabaseInfo.
2023-04-11 13:36:18.4418|INFO|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Starting Verifying all the data sources are embedded.
2023-04-11 13:36:18.4418|TRACE|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Finished Verifying all the data sources are embedded.
2023-04-11 13:36:18.4418|INFO|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Starting Verifying connection strings are valid.
2023-04-11 13:36:18.4574|TRACE|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Finished Verifying connection strings are valid.
2023-04-11 13:36:18.4574|INFO|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Starting Streaming model to Analysis Server.
2023-04-11 13:36:18.4574|ERROR|76|Error Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Error Failed Streaming model to Analysis Server, Exception System.IO.IOException: There is no data in the database for @CatalogItemId=30274bd2-dd80-4410-b667-f836519b34b4;@ContentType=DataModel
at Microsoft.ReportingServices.CatalogAccess.Streams.VarbinaryReadableStream.InitializeDatabaseAccess()
at Microsoft.ReportingServices.CatalogAccess.Streams.VarbinaryReadableStreamFactory.CreateExtendedContentReadableStream(Guid catalogItemId, ExtendedContentType contentType)
at Microsoft.ReportingServices.CatalogAccess.CatalogItemAccessor.GetExtendedContentReadable(Guid catalogItemId, ExtendedContentType contentType)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.LoadModel(AsDatabaseInfo asDatabaseInfo)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()
2023-04-11 13:36:18.4731|TRACE|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Finished Streaming model to Analysis Server.
2023-04-11 13:36:18.4731|ERROR|76|Error Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Error Failed Data Refresh, Exception System.IO.IOException: There is no data in the database for @CatalogItemId=30274bd2-dd80-4410-b667-f836519b34b4;@ContentType=DataModel
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()
2023-04-11 13:36:18.4731|TRACE|76|Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Status: Finished Data Refresh.
2023-04-11 13:36:18.4887|TRACE|76|Error Processing Data Model Refresh: SessionId: f1077666-e1e2-4925-a915-251fde0c2753, Exception System.IO.IOException: There is no data in the database for @CatalogItemId=30274bd2-dd80-4410-b667-f836519b34b4;@ContentType=DataModel
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteStep[T](Action`1 methodToExecute, T arguments, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, Boolean sendToTelemetry)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.ProcessDataRefreshEvent()
2023-04-11 13:36:18.7856|TRACE|65|Processing Data Model Refresh: SessionId: 287eb951-0410-4515-89fd-b4338d345abf, Status: Finished Saving model to the catalog.
2023-04-11 13:36:18.7856|TRACE|65|Processing Data Model Refresh: SessionId: 287eb951-0410-4515-89fd-b4338d345abf, Status: Finished Data Refresh.

How do you think about this error?

Hi @v-yanjiang-msft 

I tried upload other report with differrent datasouce. I also create one more a new schedule with a current report (that already had a normal schedule ). Both cases  the schedule did not run and throw the same the error as above.

Best regard!

[v-yanjiang-msft]

Hi @Anhsang84 ,

There can be a variety of reasons, I suggest you investigate by the below tools for more specific information:

Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

Best regards,

Community Support Team_yanjiang

[v-yanjiang-msft]

Hi @Anhsang84 ,

From the log, there is an error message "There is no data in the database for..."

It seems somethink wrong in the data source, please check if the data source is available or try to create a new report based on the data source.

Best regards,

Community Support Team_yanjiang

[v-yanjiang-msft]

Hi @Anhsang84

I can't reproduce the problem so far, if you have a pro license, I suggest you create a support ticket for free, a dedicated engineer will come and dig into by the backend logs. It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

For how to create a support ticket, please refer to: How to create a support ticket in Power BI - Microsoft Power BI Community

Best regards,

Community Support Team_yanjiang