Datamart and DAX limitation

[astiw]

Hi Team,

Want to explore datamart and use its RLS feature, but found datamart may not replace datasets as datasets are rich in dax support.

I see we can create Measures in datamart but i coulnt find way to add computed columns/ computed/derived tables using dax query. Even for role defination all mappings are static, like power bi desktop.

[v-yetao1-msft]

Hi @astiw 

Datamart does not support the creation of columns/ computed/derived tables . Currently it only supports the creation of measure. Datamart is not a complete replacement for dataset.

https://learn.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-get-started#create-a-... 

https://learn.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-overview#when-to-use-...

Best Regards,
Community Support Team _ Ailsa Tao