Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
@KrishnaUDtrucks 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
@KrishnaUDtrucks 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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |