Skip to main content
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: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

VilleQvist

Hierarchies are not visible when using analyzing excel

Submitted by Advocate I 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
Anonymous
Not applicable
‎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
Advocate I
Advocate I
‎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?

Anonymous
Not applicable
‎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, @Anonymous ! Can you plase share a link to submitted ticket? Did you solve this issue somehow?

Anonymous
Not applicable
‎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