Automated SIgma/Summarization

Hey peeps,

i already tried to find a solution by searching around in BI itself, but no success.

Lets assume we are importing an Excel sheet that is provided by another user. Now we want to use this form as a mapping table for our project. It contains a huge amount of columns with numeric values in it. 

PowerBi now sets every column with the logic "Summarization: Sum". I did not find any way to select all columns and set them all to "Don't summarize". By today, i do not understand the advantage of this automated recognition...neither the useage of this summarization. Perhaps someone can explain it to me.

I could bypass that legwork by unpivoting the columns, but this should not be the usual way, or?

Is there an option to turn this issue off?

Thanks for your help