Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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.

 

1.PNG

 

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 3
Greg_Deckler
Super User
Super User

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!