Multi-Dimensional Planning Cube: "Pivot error: Hierarchy error: Input row hierarchy has no root node

[DomPower]

Hi folks,

I’m seeking for help to create a Multi-Dimensional Planning Cube. This is my setup:

• Adventure Works sample data storge in a Direct Lake Semantic Model
• Rows: 2 Dimensions from the Customer table
• Columns: Year, Quarter, Month column from the Calendar table
• Valus >measure „Gross Profit“

Please, take a look at my submitted screenshots to get a better idea of my setup.

Anyway, I follow the instructions provided on https://learn.microsoft.com/en-us/fabric/iq/plan/planning-how-to-create-cube .

Thus, I click:

• Insert Column > Number >Insert a new empty series
• Submit the title „Plan 2027“
• Inserted as „Visual Measure“
• Add a breakdown >make sure all dimensions are added >in this case market_en_name as well as product_en
• Click Create

In every case I tried I also get the error "Pivot error: Hierarchy error: Input row hierarchy has no root node".

Even though the message seems clear I don’t understand what I need to do with the row hierarchy.

I tested:

• several dimensions
• a mix of dimensions
• Added [Driver Measure] !== BLANK in the Formular field >[Gross Profit] !== BLANK

However, I always hit the same error.

What’s wrong here? Can you help me?

Thank you in advanced.

Cheers,

Dom
Added fields
my breakdownMy Planning TableMy new column

[Nabha-Ahmed]

Hi @DomPower 

The error “Hierarchy has no root node” usually happens when the row hierarchy is not fully connected or contains gaps (missing parent level / broken hierarchy path).

Try this:

Ensure all hierarchy levels have valid relationships (no nulls between levels),Start with a single simple hierarchy ,,,Verify Calendar hierarchy is strictly continuous (Year → Quarter → Month),,,Remove any empty members in dimension. And Rebuild the cube after simplifying breakdowns

If it still fails, it’s a current Fabric IQ limitation with complex multi-dimension breakdowns in Direct Lake, and you may need to reduce hierarchy complexity or split the mode.

hope this help you !

best regards!

Nabha Ahmed