Power BI Gateway Error - [{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1

Hello, I have a very strange issue with our Power BI on-premise gateway.

Environment: Citrix

SQL Database

On-premise installed on the same database server within Citrix

This has been running fine for over a year, suddenly we are getting these random errors, the table it is highlighting is a sql view and this varies everytime we attempt to refresh so in this iteration of the error , it is complaining about the user Security table , however in another iteration it will be the Company table.

The strange thing is when refreshed locally all works fine until when deployed to the service then the refresh fails with this error, any help you can offer will be appreciated.

BTW, we are working on migrating our database out of citrix to azure but in the meantime we need to get our reports working.

Thanks again

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_GatewayCorruptedFileOrDirectoryError","pbi.error":{"code":"DM_GWPipeline_Gateway_GatewayCorruptedFileOrDirectoryError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The file or directory is corrupted and unreadable.\r\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147023504"}}],"exceptionCulprit":1}}} Table: User Security.
Cluster URI: WABI-UK-SOUTH-C-PRIMARY-redirect.analysis.windows.net
Activity ID: a59650cd-7f40-42ca-828b-a09349c3bf1e
Request ID: 42446fdd-d781-0290-ae71-a96959cb6110
Time: 2024-02-07 16:39:33Z