Forum Discussion
Solved
Excel Pivot generates invalid MDX when collapsing nested hierarchies against Power BI dataset
When using a Power BI dataset in Excel, we get an error when using 2 nested dimensions and just try to collapse one of the elements. See error attached. We get this error with every dataset / semanti...
Hi markuskolpext ,
This is a known bug and your workaround is still probably the best way and/or change your nesting (which is not even close to ideal). Perhaps you can search for this issue in the Ideas and see if you can vote for it there.
Thanks collinq for your quick response.
It's really not ideal, especially when almost every users gets into this bug. I ask myself where Excel Pivot as frontend for Power BI models is heading ? ... but anyway, we got a live with it right now.