Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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,
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
Thanks for your reply. I have solved the problems already thank!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.