Scientific Format in Dataset .csv - PLEASE HELP!

[irnm8dn]

I have a source file that is in a .csv format.  One of the columns is presenting data in a scientific format.  Regardless of trying to change format in the .csv, Power BI wants to convert the records.  Additionally, the .csv once saved and reopened, also reverts.

Is there a way in Power BI to interpret this columns as Text or Number and have the file interpret the values properly as they come from the source?

Thanks.

BTW, have tried all the recommended tricks in both Excel and in the community.

[Greg_Deckler]

What does your data look like, something like:

1e+13

?

[irnm8dn]

@Greg_Deckler

Example from the .csv is:

1.38206E+11

1.38206E+11

1.38206E+11

1.38233E+11

Upon import in Power BI it looks like:

Additionally, the problem is that the conversion to Scientific and then ultimately the Power BI interpretation is changing the values received from the source.  (And in some cases taking these unique values and making them look like dupes...)

Thanks.

[Greg_Deckler · Accepted solution]

Perhaps

let
    Source = Csv.Document(File.Contents("C:\temp\powerbi\science.csv"),[Delimiter=",", Columns=1, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Column", type text}})
in
    #"Changed Type"

?

[irnm8dn]

@Greg_Deckler

Can you step me through how to do this.  I am still a bit of a newb.

Where, how, etc. the statement below (or one like it) neeeds to be applied would help a great deal.

Thanks.

[Greg_Deckler]

So, what I did was to replace the default Change Type step in the query. So, I selected that step in the query editor and then I right-click the column and change the type to text and it asks if I want to replace the current step, I say yes.

Could be more specific if you could paste your query code from the Advanced Editor.

[irnm8dn]

@Greg_Deckler

Thanks, this seemed to move me incrementally forward.  What I don't understand is once the relationship is made, why my table is not showing me a correct output, by the desired dimension?

The left most column should be a list of Customers.