Reply
Frequent Visitor
Posts: 6
Registered: ‎12-11-2018
Accepted Solution

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.

 


Accepted Solutions
Moderator
Posts: 9,540
Registered: ‎03-10-2016

Re: Getting error when refreshing my excel data

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Moderator
Posts: 9,540
Registered: ‎03-10-2016

Re: Getting error when refreshing my excel data

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor
Posts: 6
Registered: ‎12-11-2018

Re: Getting error when refreshing my excel data

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