Forum Discussion
Solved
Remove Summation on Power BI SQL Server Column
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 no...
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.