Getting error when refreshing my excel data

[Louiselam]

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.

[v-yuezhe-msft · Accepted solution]

@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]

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