Is there an option to remove dimension name in front of column name

Question

I'm using import data from the Analysis Services to excel . Is there an option to not show the dimension in front of the column name on my tabular table?

I will try search in properties of dimension but i dont find any option how visible name

David Browne - Microsoft · Accepted Answer · 2024-07-07 14:26:38Z

0

Yes. Open the Power Query editor and new Analysis Services source. Then paste in a custom DAX query that renames the columns to whatever you like. EG

evaluate SELECTCOLUMNS(Customer, "Customer ID", Customer[Customer Id], "First Name", Customer[First Name], ...)

answered Jul 7, 2024 at 14:26

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there an option to remove dimension name in front of column name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related