cancel
Showing results for 
Search instead for 
Did you mean: 

Can't refresh dataset

I use a gateway to conncect my dataset in the share drive with Power BI. It works well during the past 4 months. But when I refreshed just now, it showed me an error. Here's the error message:

Last refresh failed: Tue Dec 07 2021 15:03:56 GMT-0500 (Eastern Standard Time)
Unable to connect to the data source undefined.Hide details

Underlying error code:-2147467259
Underlying error message:The column 'Column12' of the table wasn't found.
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.Detail:Column12
Microsoft.Data.Mashup.ValueError.Reason:Expression.Error
Cluster URI:WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID:6e7803ce-382d-4e78-9c69-26965765ec81
Request ID:be321cb3-8022-5707-d284-dfdb9de4c6e4
Time:2021-12-07 20:03:56Z

Can someone help me? I appreciate it.

Status: Investigating

If confirmed that there is no column named 'Column12' and you have not changed the column name or delete any columns in your data source, suggest that you can create a support ticket here for further help if this issue is urgent for you.

Support Ticket.gif

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Investigating

Based on the error message, 'The column 'Column12' of the table wasn't found.', please check whether this column has been changed name or deleted in your data source.

 

Best Regards,
Community Support Team _ Yingjie Li

Meng-Wang-21
New Member

Hi Yingjie, thank you for your reply. I don't have 'Column12' and I didn't delete any columns. So not sure why it shows this error.

 

Michelle

v-yingjl
Community Support
Status changed to: Investigating

If confirmed that there is no column named 'Column12' and you have not changed the column name or delete any columns in your data source, suggest that you can create a support ticket here for further help if this issue is urgent for you.

Support Ticket.gif

 

Best Regards,
Community Support Team _ Yingjie Li