Forum Discussion

condolar's avatar
condolar
Helper I
3 years ago

Scheduled Refresh Error

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

Need Help

4 Replies

  • Xaraja's avatar
    Xaraja
    Helper III
    3 years ago

    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's avatar
      condolar
      Helper I
      3 years ago

      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.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    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.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    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.