need help, csv import error transaction id text vs number.

[Anonymous]

I'm trying to import a csv file that contains a comlumn of Transaction IDs in the formats of

5202487864
5202645984
D2AC65F102922E57AC6C3F32E4A17EAB

Upon impoting, Power BI assigned the ID column as numbers and deemed the alphanumeric IDs as errors. I am using a folder import so this folder has many csv for each month going back years.

As part of the import process i went though the transformation step to add a setp to convert the transaction id column to "Text" instead of "Number". But that did not help. How can I fix it?

[selimovd · Accepted solution]

Hey @Anonymous ,

make sure you put the transformation step "Text" instead of "Number" at the beginning of the transformation.

Then go step by step and check if there is another tranformation to "Number" that might cause the error.

Usually the error happens because there is one step at the beginning that transforms it to a "Number". If you then try to transform it to a "Text" it won't help much because the error happens then at the first transformation.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Icey · Accepted solution]

Hi @Anonymous ,

---

As part of the import process i went though the transformation step to add a setp to convert the transaction id column to "Text" instead of "Number". But that did not help. How can I fix it?

---

You can just change the data type in the "Changed Type" step like this:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd · Accepted solution]

Hey @Anonymous ,

make sure you put the transformation step "Text" instead of "Number" at the beginning of the transformation.

Then go step by step and check if there is another tranformation to "Number" that might cause the error.

Usually the error happens because there is one step at the beginning that transforms it to a "Number". If you then try to transform it to a "Text" it won't help much because the error happens then at the first transformation.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic