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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

SSAS hierarchy

Hello

 

I'm trying to use SSAS hierarchy with Power BI

 

When I get data, I see my hierarchy

 

When I  get dataWhen I get data

But in my report, they don't appear as a hierarchy

The result I getThe result I get

I was expecting that

The result I wantThe result I want

I just did it manualy on order to screen it but I don't want to ask to my user to do it each time

 

What did I miss? 

 

SSAS is multi dimentional, it's a 2010 version, database are in sql 2012

 

Thank you

 

Emmanuelle

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

You may try live connection instead.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hello Sam, 

 

It don't allow me to use live connectionhierarchy40.png

 

I was under the impression that hierarchy should work also with import. Am I mistaken about that? 

 

Thank you

 

Emmanuelle

 

@Anonymous,

 

You may check the post below.

https://community.powerbi.com/t5/Desktop/Connect-Live-SSAS-MD/td-p/68251

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.