SQL as Data source - Certain Columns gets Summed

[Gautham]

WHen I tried to Import data from SQL as data source in the response certain column gets summed up in the visualization automatically .How to get rid of that ?

[v-yulgu-msft · Accepted solution]

Hi @Gautham,

Select the numerical column which you don't want it to be summed up automatically, change its defaul summarization to "Don't summarize".

Best regards,
Yuliana Gu

[Gautham]

When I query a table and get the response I see few of the columns are summed columns and few are ordinary columns I dont want summed columns in the default response.