Problem extracting data from Sales Force

[Ortignano]

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 

[Anonymous]

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?

[Ortignano]

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

[Anonymous]

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

This will help us to help you.

[Ortignano]

I can't share data and in desktop version, I solved the issue by downloading an add-in and so I use the extraction data as a source for power-bi and not it works.