Forum Discussion
need help, csv import error transaction id text vs number.
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?
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi 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.
2 Replies
- selimovd
Most Valuable Professional
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic - Icey
Community Support
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.