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

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