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.

SSAS Multidimensional Self Referencing Parent Child Hierarchy Error

We have setup a Parent Child Hierarchy with 5 levels in our Multidimensional SSAS cube.  When we do a live connection to the cube and pull in the hierarchy with the NamingTemplate defined, we get:

 

Error Message:
Couldn't load the model schema.

 

Internal error prevented loading the schema:
An internal error prevented loading the model schema associated with this report.
Please try again later. If the issue persists, contact Power BI support.

 

Once we remove the names from the Naming Template, Power BI recognizes the hierarchy and assigns generic Names: Level1, Level2, Level3, etc. to the data. 

 

The hieararchy performs just fine in an Excel Pivot Table with the NamingTemplate populated. Any help would be appreciated in getting Power BI to recognize the hierarchy. 

Status: Needs Info
Comments
v-haibl-msft
Employee

@lntuck

 

Have you set the name of one of these levels to the same name as another attribute in the dimension? If yes, this problem has been reported to Power BI team internally before (CRI 33005704) and it is by design. The workaround is to rename the parent child level to a different name.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info