6

Be able to set Summarize By property for fields for SSAS Tabular endpoints

When creating a SSAS Tabular endpoint from a Semantic Model and consuming it in PowerBI you will find that all numeric fields are given Sum() as default Summarization. While this makes sense in many cases, it doesn't in others.

I.e. you may have a code that is stored as a number, but should not be summed. In SSAS Tabular databases you can set the 'Summarize By' property on a field. It would be very useful to be able to set this property from Discovery Hub.

I do not like the generally proposed solution of converting non-metric numerical fields to character types to avoid summarization, as it feels wrong to change a DWH layer for such a reason.

See the following link for some further context: https://www.sqlchick.com/entries/2017/11/22/why-the-default-summarization-property-in-power-bi-is-so-important 

2 comments

Post is closed for comments.