Data format error

skai · ‎01-25-2024

"We encountered the following error while fetching additional rows: "DataFormat.Error: We couldn't convert to Number."
Preparing a dataflow with a text file, however i get this message when i scroll down. Cant identify the column/row that its referencing. Datatypes are on autodetect, i have no time/date columns.
I can save and close however data flow doesnt refresh: Error: DataFormat.Error: We couldn't convert to Number.

NandanHegde · ‎01-25-2024

Hey,

The error usually comes when there is some text characters which cannot be converted into numbers.

similar thread : https://community.fabric.microsoft.com/t5/Power-Query/DataFormat-Error-We-couldn-t-convert-to-Number...

To debug, get the distinct values from that column and check :

https://community.fabric.microsoft.com/t5/Desktop/Power-Query-Extract-distinct-values-from-column-as...

----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com