Forum Discussion

IntaBruce's avatar
IntaBruce
Resolver 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 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

 

Need Help

7 Replies

  • IntaBruce's avatar
    IntaBruce
    Resolver I
    4 years ago

    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.

      • smpa01's avatar
        smpa01
        Community Champion
        4 years ago

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

         #"Changed Type"

         

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community 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.