Scheduled refresh failed

[ffw105]

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. 

[ImkeF · Accepted solution]

Hi @ffw105 ,
I would go to the query editor in PBI desktop and look for the table where this error message has been generated.
Proceed through every step of the query to see where it fails.
Maybe the columns have been removed from the source?

[ffw105]

Hi @ImkeF , thank you, I thought I was going mad as that was my conclusion too, we have contractors that have messed about the data source, that was the reason.