how to avoid the imported variables to be zummarize

[Anonymous]

Hello,

When I am importing a SQL table in Power BI, for some reasons, I don't know, almost 1/3 of all the variables into the table are summarized. 

So on a table with 100 variables, I need to select one by one variable and select don't summarize from the modeling tab.

Is there a way to avoid that?

regards,

alepage

[v-juanli-msft]

Hi @Anonymous 

If you are in the first scenario, you could right click on the field and select "don't summarized".

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Good morning,

I'm sorry for asking a question lacking clarity.  If you go to this address (https://community.powerbi.com/t5/Desktop/Why-is-the-sum-symbol-appearing-at-the-sidebar/td-p/122630)

you will see the example of the table Q13.  The issue, I have is similar.  Just imagine that I click on get data, then select sql data base, then enter the server name and the database name then I click on OK.

My table is imported into Power BI .  My table could contains about 100 columns and among those columns, may be 1/3 show come with a summation sign as in Q13.

Imagine the waste of time to select those variables, one by one then select don't summarize.

What I would like to know, if there is a way to avoid the variables from an imported table to be summarize at the begining.  If some need to be summarized, I would like to have the choice to do it, not by default.

Regards,

alepage

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

It can reproduce your problem.

It is a behaviour by default.

You could submit an idea here so that it may be achieved on the way.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @Anonymous 

Do you add columns in a table visual, then the column summarize in this table?

Or it summarize in the data model?

Best Regards
Maggie