Fail to import data into Power BI Desktop,get "Expression.Error: The number is out of range" error

[Anonymous]

Hi, 

I'm trying to import data into power BI Dekstop, data source is Salesforce Report. But I'm getting "Expression.Error: The number is out of range of a 32 bit integer value." error, suspected is the time duration in source table , anyone have the solution? try to convert this column into text , but still unsuccessful. 

 

[sorathecat]

@Anonymous  Hey, i am currently experiencing this issue too when trying to import life cycle reports from salesforce with the duration having the same error. How did you manage to resolve this? Would appreciate it if you can let me know. Thanks!

[v-cherch-msft]

Hi @Anonymous

You may have a look at below post and check if it's helpful.

https://social.technet.microsoft.com/Forums/ie/en-US/23cc091d-d104-42dd-a5a0-e4067845f5d5/the-number-is-out-of-range-of-a-64-bit-integer-value-details?forum=powerquery

Regards,

Cherie

[Anonymous]

hi @v-cherch-msft, 

Tried to change data type to number, still having same error, not really familar with M query ,  Attached the code i wrote, let me know if my coding is wrong, thank you 

 

[v-cherch-msft]

Hi @Anonymous

You may check the data type as below and try 'Duration'. If it is not your case, you may submit a support ticket.

https://powerbi.microsoft.com/en-us/support/

Regards,

Cherie