Forum Discussion

IntaBruce's avatar
IntaBruce
Icon for Resolver I rankResolver I
4 years ago

Int Overflow

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 tr...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

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.