Skip to main content

Power BI

Merged

"Display folders" above table level in data model

Vote (89) 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.