Calculated Columns in DirectLake Semantic Model

[GitBen-dorid]

Hi All,

Is it possible to get a list of calculated columns out of a direct lake semantic model, every way I have tried seems to surface regular columns but never the Calculated columns?

[m-kovalsky]

Calculated columns are not supported in direct lake mode.

[GitBen-dorid]

your right, I have a had a lapse in memory, i am trying to set OLS on measure, and somewhere along the line got confused!

sorry for wasting your time

[m-kovalsky]

You can always use this. It will show you the column type (and other properties) of all columns in the semantic model.

import sempy.fabric as fabric
fabric.list_columns()

[GitBen-dorid]

Thanks, I can get the list of measures out but it looks like setting OLS is not yet supported

[m-kovalsky]

https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#set-object-level-security-ols

[GitBen-dorid]

This is the code I am using but it fails to find the measures and skips them

[m-kovalsky]

OLS is not for measures. It’s for columns or tables.