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 convert the value null to type Logical.

 

But i am not able to identify which rows or column has issue.

 

thanks.

 

Need Help
  • 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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    • Louiselam's avatar
      Louiselam
      Frequent Visitor
      7 years ago

      Thanks for your reply. I have solved the problems already thank!