Getting Duplicated columns from SSAS multi dimensional source

[Anonymous]

Hello my dear community members,

I have a ssas multidimensional cube and I have connected the cube to Power bi desktop. when I bring the measure in values and week num and material planner number in Rows and columns its showing the duplicated data like below.

But when i check these values in SQL base tables they are fine. Does anyone knows why this happening? let me know your inputs and thanks in advance.

[Greg_Deckler]

@Anonymous Wondering if perhaps you need to do a trim and clean on your data coming in. It's almost as if the Material Planner column has values like "100" and "100 " for example.

[Anonymous]

If it is the case Power Bi will not show 100 and 100 in different columns @Greg_Deckler

[Greg_Deckler]

@Anonymous Was just an example. It depends on the non-printing character. For example, if there is a line feed ( ASCII 13) for example at the end, then 100 and 100<lf> will show as different columns in the matrix although the lf will not print in the visual so it will look like 100, 100. See attached PBIX below signature.