Forum Discussion

stack23's avatar
stack23
Advocate II
7 years ago
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...
  • TomMartens's avatar
    TomMartens
    7 years ago

    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

TomMartens's avatar
TomMartens
Super User
7 years ago

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