Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a report that has a matrix with a ragged hierarchy. I used SQLBI's strategy to handle this (Parent-child hierarchies – DAX Patterns). Some projects that I slice for go deep in the hierarchy and others do not. This report works fine on Power BI Desktop, but on the workspace, it freezes when I select certain slicer values in the project slicer and gives me the error in the above message. The maximum level this hierarchy can get to is 8. It does not even work when I remove all the measures from the values. Why would this work on desktop and not on the Power BI workspace?
Have you tried clearing your cache or changing your browser? If not, please try that to see if it solves your problem. If the problem persists, please feel free to ask me.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have tried on chrome and edge and this has not worked
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 31 | |
| 17 | |
| 14 |