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.
How do I remove a summation property for a Power BI SQL table? I have a Customer Transaction Table. For some reason PowerBI is trying to Measure Sum the CustomerTransactionId primary key row. I do not want this added. Please see picture below.
I just want to display all rows in a table.
CREATE TABLE [dbo].[CustomerTransaction]
(
[Customertransactionid] [int] IDENTITY(1,1) primary key NOT NULL,
[Customerid] [int] NULL,
[Quantitybought] [int] NULL,
)
[1]: https://i.stack.imgur.com/qg0A1.png
Solved! Go to Solution.
Hey,
if you can change the default aggregation function used for numeric columns, this will work either in connections to SQL Server tables in "direct query" or "import" mode.
Mark the column and in the Modeling menu you can change the "Default summerization" for the column to: Don't summarize
Please be aware that is a limit of 1 MIllion rows that can be returned by a query utilizing a connection in "Direct query" mode.
Maybe you might consider to change the summerization to "Count".
Regards,
Tom
Hey,
if you can change the default aggregation function used for numeric columns, this will work either in connections to SQL Server tables in "direct query" or "import" mode.
Mark the column and in the Modeling menu you can change the "Default summerization" for the column to: Don't summarize
Please be aware that is a limit of 1 MIllion rows that can be returned by a query utilizing a connection in "Direct query" mode.
Maybe you might consider to change the summerization to "Count".
Regards,
Tom
In the Values area, click the drop down next to the column in question. Choose "Do not summarize". Or you can change th default aggregation method in the model.
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |