Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number..

Dear Al

 

i have excel file with more than 50 columns, and updated data to multiple column, after referesh in Power BI, i received error: OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number..

i don't which columns belongs to

 

how can i fix this issue

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous . Open power query and check is it showing error folder or some red line below a column.

     

    Otherwise you have check for column which is number that can have text value or value like #N/A or -