Forum Discussion
Problem extracting data from Sales Force
Hi all,
I'm looking to extract data from Company Sales Force Objects and I want to look at the last 365 days of data. When I'm looking at Column Profiling on top 1000 lines I don't have a problem but when I look at the entire data set the profiling gives me unexpected error and go ahead I receive the following error:
DataSource.Error: Numeric Overflow
Details:
[List]
Do any idea to solve the issue (I tried to remove the error from a data column but still doesn't work)
Antonio
Looking at
4 Replies
Hi Ortignano,
I think Numeric Overflow means there are too many numbers in a cell for Power BI to handle. Would any of the lines have data that have decimal places e.g. 1234.56? If so, the ".56" might actually be e.g. ".56349572048302057302845" up to an infintie number of decimal places which may be too many for Power BI to handle. Can you check if the source data actually has many more decimal places than is being displayed?
Edit: Or add a step in Power Query to round data to e.g. 2 decimal places?
The problem is that I don't know which column can give problems. I receive error with following step
= Table.Sort(#"Removed Columns",{{"CreatedDate", Order.Ascending}})
I guess that is createddate that give me problem but it seems ok
Hi Ortignano,
Can you export the whole table into Excel and look at the CreatedDate column to check for any strange values?
If possible, can you provide a sample of the data or the entire table by uploading it as described here? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
This will help us to help you.
