Solved: Scheduled refresh failed

ffw105 · ‎08-24-2023

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 · ‎08-25-2023

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?

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎08-25-2023

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?

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

ffw105 · ‎08-28-2023

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.