Forum Discussion
Arithmetic overflow error converting expression to data type int' - left join on 2 SQL tables
I've getting this ' Arithmetic overflow error converting expression to data type int' error when I try to do a left join of 2 SQL tables. I can pull both tables in individually with no issue using a...
Hi Phoenix_Bird
May be there are something wrong with your data. Could you take a test on simple data with the same left join SQL statement and same data type? Then judge where the problem is by the result. Or could you add more details? so that we can work on it further.
If you are in a hurry to use data after left join and currently can’t solve this problem, you can use the function Merge Queries in Power Query Editor to process data as an alternative after pulling both tables in individually.
Hope it helps!
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.