cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

VilleQvist

Hierarchies are not visible when using analyzing excel

Submitted by on ‎10-06-2020 01:01 AM

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 those hierarchies in Power BI desktop and also in Power BI service, only place where I can't find those is excel. Do we have some changes, or what was happened?

Status: New
See more ideas labeled with:
5 Comments (5 New)
Comments
drum1010
Advocate II
Advocate II
‎10-06-2020 07:17 AM

by chance, are you using both direct query and import modes on your model? we encountered this same issue with missing hierarchies (only in analyze in excel) when we added a direct query table to our existing data set (which were all set to Import Mode).

VilleQvist
Frequent Visitor
‎10-27-2020 12:06 AM

@DR You were right, there was a new direct query in the dataset. In my opinion, this is a bug but do we have any workaround?

drum1010
Advocate II
Advocate II
‎10-27-2020 05:21 AM

@VilleQvist Not sure if it is a bug. I haven't asked the question. I would submit a support ticket with Microsoft to get their feedback on it. 

Anonymous
Not applicable
‎09-20-2021 06:31 AM

Hello, @drum1010 ! Can you plase share a link to submitted ticket? Did you solve this issue somehow?

drum1010
Advocate II
Advocate II
‎09-20-2021 06:35 AM

@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.

Idea Statuses