Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |