Categories: SSAS

Nested Display Folders in SSAS

Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is a fancy term for a live connection to an SSAS cube or model. Anyway, great news, as it drastically improved usability of Power BI Desktop when browsing cubes.

On the same day, I also found out it’s possible to nest display folders in SSAS. Which was even better, because I have a project with dozens of measures and this functionality really makes the difference. All you have to do is putting backslashes to indicate where a new child folder begins:

ssas_displayfolders_01ssas_displayfolders_01

And voila:

ssas_displayfolders_02ssas_displayfolders_02

It even works in Power BI Desktop (make sure you have the latest update):

ssas_displayfolders_03ssas_displayfolders_03

Time for a happy dance!

happydance


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
FacebookFacebookMastodonMastodonEmailEmailShareShare
AddThis Website Tools
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Recent Posts

Execute Fabric Data Pipeline from Azure Data Factory

In the blog post Call a Fabric REST API from Azure Data Factory I explained…

1 day ago

Azure Data Factory Pipeline Debugging Fails with BadRequest

I recently had a new pipeline fail. It was actually a copy of an old…

4 weeks ago

Call a Fabric REST API from Azure Data Factory

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data…

4 weeks ago

Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse).…

1 month ago

How I passed the DP-700 Exam

I recently took and passed the DP-700 exam, which is required for the Microsoft Certified:…

2 months ago

Take over Ownership in Microsoft Fabric

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a…

3 months ago