Forum Discussion
Getting Duplicated columns from SSAS multi dimensional source
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.
3 Replies
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.
If it is the case Power Bi will not show 100 and 100 in different columns 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.
