Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Change default summarization in default semantic model

In a lakehouse I have a table with several columns that are things like week number, or month number - whole number columns that will never be aggregated.

 

I'd like to change the default summarization on these to "do not summarize" - at present Power Bi tries to aggreagate them. How can I do this, so it takes effect when people connect to this data either by connecting to the lakehouse SQL analytics endpoint or connecting to the default semantic model of the lakehouse (they'll do the lakehouse option more often to get the data in import mode).

  • Hi Anonymous you can do this by:

     

    • Open the SQL Analytics Endpoint for the Lakehouse
    • Switch to the Model tab (bottom of the screen)
    • Select a column and change the Summarize By under the Advanced options on the right hand side.

     

1 Reply

  • AndyDDC's avatar
    AndyDDC
    Most Valuable Professional

    Hi Anonymous you can do this by:

     

    • Open the SQL Analytics Endpoint for the Lakehouse
    • Switch to the Model tab (bottom of the screen)
    • Select a column and change the Summarize By under the Advanced options on the right hand side.