Forum Discussion

Lachlanpap's avatar
Lachlanpap
Frequent Visitor
1 year ago

Power Query - We cannot convert the value null to type Number.

Hello, I keep getting the below error when loading data into Power Bi despite having now issues with the data in power query.    OLE DB or ODBC error: [Expression.Error] We cannot convert the value...
Need Help
Lachlanpap's avatar
Lachlanpap
Frequent Visitor
1 year ago

Thanks for your response Pete.

 

The 'RequiredRows' column is returning 0 when an arrival and departure time is less than 1 hour. I created a conditional column 'RequiredRows1' that if 'RequiredRows' = 0 then return 1. This was done so I could then enter the below M code which adds a row for each hour between arrival and departure time. If I didn't do this the 'Custom' column would return a null for any row less than 1 hour. 

 

I hope this makes sense. Thanks

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Lachlanpap ,

DIdi the solution BA_Pete  offered help you slove the problem, if it helps you can consider to accept it as a solution so that more user can refer to, or if you have problems you can provide some information so that can provide more suggestion for you.

 

Best Regards!

Yolo Zhu