How to prevent Power BI to aggregate the fields?

[Anonymous]

Hi, I'm learning Power BI, and I imported 2 tables and created a link between them. Now I want to just display the data, so I placed a "table" control, the annoying thing is that in the field list, Power BI automatically summerized the fields with number type.

I know that when I drag the field to the report, I can choose "Don't summerize", but it is quite annoying considering that there are quite a lot fields.  I remembered that last time I tried it, it show field directly, how to prevent Power BI do this summery?

Thanks a lot. 

[calerof · Accepted solution]

Hi @Anonymous, 

You can go to the Model view, select your table and then select all the fields in bulk that you want to change its default way to summarize values and change it to None. Here:

Hope it helps.

Regards,

Fernando

[Anonymous]

Hi, Calerof, It works! Thank you so much!