Int Overflow

[IntaBruce]

Hi,

I am receiving the following error when trying to import tables from SQL Server to Power BI

As far as I can tel none of the numeric fields are integer because I have told the query editor to treat them all ast text.  So what is going wrong?

I'm not sure exactly how many rows there are in the table but it fails at around 480,000

[IntaBruce]

I have managed to avoid but not actually solve the issue.

The Case_Timeline table had columns in the database for number of days, hours and minutes and these were decimal values.  The columns were actually not required because Open and Close date and time are available so the duration can be caluclated in Power BI if I ever need it.  But since (at this time) I don't then I simply excluded those columns from the load and it worked fine.

[v-angzheng-msft]

Hi, @IntaBruce 

Returning the appropriate data types for the above two queries will solve your problem.

This value 63555667966 is outside the maximum data range for int-type data.

Int: (-2,147,483,648 to 2,147,483,647)

Unsigned int: (0 to 4,294,967,295)

Data Type Ranges

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

Can you share your query M code?

[IntaBruce]

Do you mean this?

[AlexisOlson]

Yes. I don't see anything wrong with it though.

If you change all of the types to text in that last step, do you get the same error? If so, I'm guessing it's an issue in the view definition or something similar on the database. Do the views load as expected on the database?

[smpa01]

@IntaBruce  do you still get the same error if you delete the following step and load?

 #"Changed Type"

[IntaBruce]

Yes I do