Forum Discussion

Louiselam's avatar
Louiselam
Frequent Visitor
7 years ago
Solved

Getting error when refreshing my excel data

Have update the Excel data by adding additional rows to the original file. However, when apply query changes, the below error comes up   " OLE DB or ODBC error: [Expression.Error] We cannot conver...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Louiselam,

    Could you please describe the detailed steps you apply to the query in Power BI Desktop query editor? It seems that one of your fields contain null values, which doesn't meet the conditions of the applied steps.

    Also please share sample data of your Excel so that I can test.

    Regards,
    Lydia