Forum Discussion
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. :smileysad:
4 Replies
v-cherch-msftMicrosoft Employee
Hi Anonymous
You may have a look at below post and check if it's helpful.
Regards,
Cherie
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