Forum Discussion
Problem extracting data from Sales Force
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.
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.