Forum Discussion

jessica-r-next's avatar
jessica-r-next
Frequent Visitor
4 years ago
Solved

MAC Address CSV Scientific Notation

I have CSV files that when importing into PBI, the MAC IDs display as scientific notation. Changing the type to text doesn't help. I find that in Excel, only formatting as text -during import- (impor...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi jessica-r-next ,

     

    If your data in the source is displayed in scientific notation, then the data will be lost when you convert it to text in Power Query (i.e. the last few digits will be zero). Based on my testing, I think you have to set the column's type to Text in the CSV file.

     

     

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

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi jessica-r-next ,

 

If your data in the source is displayed in scientific notation, then the data will be lost when you convert it to text in Power Query (i.e. the last few digits will be zero). Based on my testing, I think you have to set the column's type to Text in the CSV file.

 

 

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

  • jessica-r-next's avatar
    jessica-r-next
    Frequent Visitor
    4 years ago

    As much as I was fearing this is the case, I do believe this is correct. I have to walk back what I said in my original post of getting import wizard to work between csv and excel. It worked for some, but not all. So, clearly my issue is at the source document. 

     

    I appreciate everyone's help on this.