Scheduled refresh - Error Processing Data Model Refresh

[PBI_user27]

Need some opinion on the error encountered as I was unable to resolve this.

Currently version of report server: May 2022. Scheduled refresh was working fine until recently with this error.

2022-08-17 06:08:38.6058|ERROR|87|Error Processing Data Model Refresh: SessionId: 02a0c685-4214-4081-8791-60de307e818e, Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Unexpected number of disk files associated with database object. Possible cause for that is missing or corrupt cryptokey.bin or detach.log file.

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()

[rakeshmistry212]

In On Premiises Power BI Report server , Refreshng Status Continue showing,

Kinldy Help, FInd the attached Screenshot

[v-henryk-mstf · Accepted solution]

Hi @PBI_user27 ,

For such issues, if the backup file is encrypted, you must first provide the password specified during the backup before you can use the file to restore the Analysis Services database. If the encryption key file is lost, you will never be able to decrypt the backup file. You cannot decrypt it using another generated CryptoKey.bin file (otherwise this would be a big security issue).
For more information, see the following documentation.

Backup and Restore of Analysis Services Databases | Microsoft Docs

Alternatively, try upgrading to a new version or reinstalling to ensure that there is enough space on the PBI RS data drive.
Also try restarting the PBIRS service and checking that the log files reside in the PBIRS folder for more details.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.