Scheduled Refresh Error

[condolar]

Hi guys,

Getting the following error on my scheduled refresh:

Underlying error code: -2147467259
Underlying error message: The column 'Column10' of the table wasn't found.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: Column10
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-UK-SOUTH-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 5cd77749-0ef8-4349-ace4-df592da9e2ef
Request ID: 63e8abf6-5782-55f1-3ff3-e23f79c51fa9
Time: 2022-10-31 17:04:32Z

Only thing is, nothing on my data sources has ever had a 'Column 10' so I am very confused. The data given in the error doesn't seem to help me find the source either so I'm stumped. Anyone have any ideas?

I have the latest version of the gateway, I am using it in personal mode and when I refresh the data manually in Desktop Power BI, there are no issues whatsoever...?

Thanks,

Connor

[v-xiaotang]

Hi @condolar 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang]

Hi @condolar 

Thanks for reaching out to us.

please go to Power Query Editor - Advanced Editor, and check code in it, find if there is column10 in it.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Xaraja]

Do you have an Excel file as part of your dataset? I got a similar error (mine was column 13) when referencing an Excel file from SharePoint and someone had clicked into a column that was supposed to be empty and typed something there (i.e., the data was supposed to end at column K and they typed something in column M).

[condolar]

@XarajaYeah it is, I have gone back through all the source files though and most of them don't extend beyond 3 or 4 columns! Super annoying that the error doesn't even specify which table is causing the issue, I don't know why it wouldn't.