Skip to main content

Data Engineering

New

Role playing dimensions in Fabric

Vote (28) Share
Scott Powell's profile image

Scott Powell on 12 Dec 2023 03:20:55

We need true role playing capabilities for dimensions in Fabric. Currently, you can include a table only a single time in a semantic model that uses DirectLake. This makes it impossible to use a dimension as a role playing dimension - for example, our date table as admit date, discharge date, surgery date, etc. Also the same for providers - there can be an admitting provider, discharge provider, attending provider, surgeon, primary care physician, etc.


We need the ability to:

  1. Use a table multiple time in a semantic model built in the service
  2. Be able to rename the table, for example rename a generic "date" table to admit date, discharge date, etc.
  3. Still have everything work properly with DirectLake


The only workaround currently is to create multiple copies of the table. This not only wastes space, but also means separate ETLs have to be updated if there's any change to the base table.


Thanks,

Scott

Comments (1)
Scott Powell's profile image Profile Picture

Jayant Jape on 04 Sep 2024 13:59:03

RE: Role playing dimensions in Fabric

need this for our customer bi solution