SSAS (multidimensional) live connection display folder

[thentschel]

Hello together, if I grab Data from a SSAS (multidimensional) live connection each Measure Group will be displayed in Power BI as a folder. If you have defined other display folders for the measures, they will dispalyed under the measure group folder. Example: „Sales Line“ > „Sales“ What I want to do is that we could Group Measures in logical Folder (in this case "Sales") and the technical folder "Sales Line" should not appear. Has anybody a hint for me, or an answer if it is possible with a multidimensional SSAS live connection?

Thanks, Thomas

[Anonymous]

Hi @thentschel ,

Based on my test,this can only be done in SSAS model then connect to power bi desktop.

Pls refer to :

https://www.mssqltips.com/sqlservertip/5120/setting-display-folders-in-analysis-services-tabular-201...

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[thentschel]

Hello @Anonymous,

thank you for your response. Unfortunately, the provided reference is about the SSAS Tabular Model, not the multi-dimensional one.

To be more precise, here is what I am struggling with:

1. SSAS MD – measure groups with measures:

2.All the marked measures share the same Display Folder:

3. Dispite the given configuration, Power BI gives me this:

4. Which corresponds to:

I hope the description is understandable.

Would be great if there was a way to not having multiple folders with the same name but distinct folder-names.

Any help appreciated.