Answered

Arithmetic overflow error importing data from SQL

(0) Share

Report

Posted on by WorksightedTS

Hello!

I am receiving an 'Arithmetic overflow error converting expression to data type varchar.' error while importing a view from SQL server. Able to import, but when I go to effect the data in power query at all it throws this error. I am only attempting to sort the data not casting any of the values.

Full error:

Message=Arithmetic overflow error converting expression to data type varchar.
ErrorCode=-2146232060
Number=8115
Class=16

All of the columns seem to match up - all of my varchar columns in SQL are being converted to text values in Power BI.

Any help is greatly appreciated! Let me know if you need more information!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @WorksightedTS To avoid this problem, make sure that the length of the VARCHAR variable or column is long enough to hold the decimal or numeric value, counting the decimal point as part of the converted VARCHAR value.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

WorksightedTS 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Ahmed, @AhmedSalih

Thank you for the input. Do you know of a good way to check the SQL database for values that are too long for the varchar length? I have about 30 or so varchar columns and I'm not sure which one needs the length increased. No errors inside SQL server or Power query indicating which column is the issue.

Thank you!

Was this reply helpful? Yes No
WorksightedTS 6 on at

Like (0)

Report
Copy link

Link copied!

@AhmedSalih

Was this reply helpful? Yes No

Verified answer

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@WorksightedTS ,

SELECT MAX(LEN(column_name)) FROM table_name;

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com