Text is being converted to camel case after loading to power bi

[Anonymous]

Hi Team,

I have a Name column with datatype string in sql server , when loaded the column to power bi few of the names have been shown converted to camel case. 

Example , I have names like Susan , susan , Yahan and yahan which loaded like Susan, Yahan and yahan. As per my understanding we should either see 2 rows loaded since query editor is not case sensitive or 4 rows, but couldnt get the reason on why 3 rows are loaded showing 2 different behaviours in same column.

Our Ideal requirement is to show what has been entered in frontend tool in this case we should see 4 rows . Please let us know your insights on the issue.

Thanks in advance

[mahoneypat]

Getting 3 values is surprising.  Does one of them have an extra space or other hidden character?  To keep the # of variations, you could do a group by step on the name column and add an index, before re-expanding it and loading the table.  Or you could use uppercase or lowercase to force it to two values (possibly with a trim, if needed for extra space).

Pat

[smpa01]

@Anonymous  can you please try this and see what this returns. Through this PQ is asked to return the table from DB but preserve the native DB's data type.

let
    Server = Sql.Databases("dataServer"),
    DB = Server{[Name="database"]}[Data],
    filteredTable = Value.NativeQuery(DB,"select * from transaction",[
      PreserveTypes = true, 
      EnableFolding = true
    ])
in
    filteredTable

.  

[Anonymous]

Hello, 

Thank you for inputs. 

My bad I missed to mention that source to power bi is analysis services tabular model and code in advanced editor is something like this. 

let
Source = AnalysisServices.Database(ServerName, DatabaseName, [TypedMeasureColumns=true, Implementation="2.0"]),
Model1 = Source{[Id="Model"]}[Data],
Model2 = Model1{[Id="Model"]}[Data],

any solution to fix this issue when tabular is the source is helpful.

Thanks,

Swathi