We have used analyzing excel a lot and it have worked fine. But yesterday suddenly all the hierarchies have disappered. The fields are still visible but premaded hierarchies are not. I can still see ...
Anonymous i did not submit a ticket- this is working by design from Microsoft. As of now, there is no workaround for displaying hierarchies in excel if both direct query and import modes are being used in a data model. Either switch all to direct query or switch all to Import to get the hierarchies back in excel.