Error refreshing Underlying error code: -2147467259

[safriguy]

Hi,

We have an important report for our firm which as of 18th October has had an error refreshing as scheduled each morning. The error on the dataset is as below:

Underlying error code: -2147467259
Underlying error message: The column '43' of the table wasn't found.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: 43
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: 9900b8c7-2d7e-470c-af83-d3a9595baee7
Request ID: a0b5da1a-956e-4785-9684-0a4a402abb97
Time: 2022-11-09 00:36:43Z

Any help would be greatly appreciated as this report is vital to our day to day. 

Thanks

[nitishsh91]

Hi @safriguy 

Is your dataset using some excel sheets to fetch the data or you takin some data from dynamic source which had this column 43 when your dataset was created and now when it's trying to refresh the data it's not able to find that reference.

open this particular table and in the query code you will find this column reference which will have to be corrected.