Skip to main content

Power BI

New

"Display folders" above table level in data model

Vote (68) Share
Vegard's profile image

Vegard on 13 Sep 2019 21:13:32

It would be nice with some kind of organizing level above the table level in a (tabular) data model in Power BI, SSAS etc. For instance, by using "Display folders" to include measures, columns etc. from multiple tables in the same folder.

There's a lot of business value to tap into between and across organizational boundries and tables, or from a wider overview, which is restricted by the tables as the top level in larger data models.

The concept quickly and superficially illustrated by a fictive AdventureWorks example: https://oxcrx34285.i.lithium.com/t5/image/serverpage/image-id/166559i041B82FEAEB0C494/image-size/large

Maybe one could also have a choice between showing the traditional table views and this virtual folder structure, when one needs the underlying tables/table structure for whatever reason.

Comments (3)
Vegard's profile image Profile Picture

6a8cce30 83c7-483b-8ff9-6b6bed87213d on 06 Jul 2020 00:09:41

RE: "Display folders" above table level in data model

This would be so useful for the end user. Please implement.

Vegard's profile image Profile Picture

8a6e7d3b f7aa-4431-a802-b71d36e291b6 on 06 Jul 2020 00:09:07

RE: "Display folders" above table level in data model

Would be very helpful. thank you!

Vegard's profile image Profile Picture

942baa77 6c30-4a93-b42f-d8882edcd6c2 on 06 Jul 2020 00:09:06

RE: "Display folders" above table level in data model

This is a major request of our developers. We have a very large, complicated SSAS Tabular model & this would be very beneficial for them to use 'common' fields easily.