Change default summarization in default semantic model

[Anonymous]

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).

[AndyDDC · Accepted solution]

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.