Forum Discussion
Expression.Error: We cannot apply operator .. to types Null and Null
I'm getting the following error when trying expand table when merging two tables in Power Query in Power BI. The problem persist with all kinds of joins. There are no null values in the datasets.
> Expression.Error: We cannot apply operator .. to types Null and Null.
> Details:
> Operator=..
> Left=
> Right=
This is how it looks after merging:
This is how it looks after hitting "Table"
This is how it looks after hitting "Table"
When hitting "Error" this shows up. This is the same error message I get when I expand it.
When hitting "Error" this shows up. This is the same error message I get when I expand it.
Okay, just to let others know that might have a similar problem I found out the solution. It was my bad, but there were instances where Table B in the merge process that had null values due to an error in the SQL database. Anyway, I replaced all those values and it worked! Thanks to Pete and Jing for the help!
