cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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

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. Smiley Sad

 

 error.png

 

4 REPLIES 4
Highlighted
Microsoft
Microsoft

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

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

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

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 

 code capture.PNG

Highlighted
Microsoft
Microsoft

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

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/

 

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

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

@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!

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors