Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Lasse_BG
New Member

Hierarchy at slices aren't working

Hi, 

When I try to add my date hierachy as a slicer in my report I get the error 

Lasse_BG_0-1626257419025.png

My Analysis server is version 15.0.32.55

Lasse_BG_1-1626257621444.png

and I do believe that's a 2019. 

Anyone else that have expirenced this or have an idea for a solution? 

BR

Lasse

 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @Lasse_BG ,

 

Based on your Analysis Server version: 15.0.32.55, I guess you are using the GDR version of SQL Server 2019 like below. Right?

sql.PNG

 

I find that hierarchy slicer is not working on RTM version of SSAS 2019.

 

RTM.PNG

 

 

And if yours is GDR version, please try to apply later cumulative update to SSAS 2019. You can download the update(CU) builds here: KB4518398 - SQL Server 2019 build versions (microsoft.com).

 

CU.PNG

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @Lasse_BG ,

 

Based on your Analysis Server version: 15.0.32.55, I guess you are using the GDR version of SQL Server 2019 like below. Right?

sql.PNG

 

I find that hierarchy slicer is not working on RTM version of SSAS 2019.

 

RTM.PNG

 

 

And if yours is GDR version, please try to apply later cumulative update to SSAS 2019. You can download the update(CU) builds here: KB4518398 - SQL Server 2019 build versions (microsoft.com).

 

CU.PNG

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

That worked, thanks!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.