Forum Discussion
Get proper column names when importing data from SSAS using MDX query
When importing data from a SSAS Tabular Model using an MDX query, the columns names that come up are like full member names e.g. [Sales].[OpportunityID].[OpportunityID].[MEMBER_CAPTION]
Is there a way to get it to show just OpportunityID or Sales.OpportunityID without having to rename each column?
FYI... The reason I'm using an MDX query is because I need to pre-filter data before it is imported.
I saw the below post a while ago, it is not a full solution to your particular problem but may serve as a starting point as long as you are comfortable doing some coding in M. I am not aware of any solution that would solve this using just the Power Query UI.
3 Replies
I saw the below post a while ago, it is not a full solution to your particular problem but may serve as a starting point as long as you are comfortable doing some coding in M. I am not aware of any solution that would solve this using just the Power Query UI.
Yes, was hoping for something through UI but worst case this is at least an option. Thanks.
