Scheduled refresh failed

Hi,

My report is set to refresh daily at 12pm, it was all working fine till last night, and this was the error message:

Data source error: DataSource.Error: <ccon>Microsoft SQL: "Invalid column name 'record1idname'.\r\nInvalid column name 'record2idname'."
RequestId: TDS;cbdf883e-a18e-4983-b698-9e95db5f597c;2
Time: 2023-08-23T16:29:57.5208884Z. DataSourceKind = CommonDataService. DataSourcePath = lcpproduction.crm11.dynamics.com. Message = "Invalid column name 'record1idname'.\r\nInvalid column name 'record2idname'."
RequestId: TDS;cbdf883e-a18e-4983-b698-9e95db5f597c;2
Time: 2023-08-23T16:29:57.5208884Z. ErrorCode = -2146232060. Number = 40000. Class = 16. </ccon>. The exception was raised by the IDbCommand interface. Table: Reason for loss.
Cluster URI: WABI-NORTH-EUROPE-I-PRIMARY-redirect.analysis.windows.net
Activity ID: 447851f2-ede3-7224-aa48-583d569a5591
Request ID: 42f8af33-bf65-8de6-e374-b8cb59b725ca
Time: 2023-08-23 16:29:58Z

Nothing's changed and I coulndn't find the column above, also couldn't refresh in desktop due to the above error. A bit stuck as how to fix it, any help would be appricated.