Showing results for 
Search instead for 
Did you mean: 
KBO Member

Datasource: Dataflow - SUM/Summarize dosen't work correctly

Hi together,

I don't know If the  headline is the right choise but let me explain:

First I create a Data Flow in Power BI Service to our NAV system. 

Then I load the Flow into Power BI Desktop Client (newest Version April 2019).

After that I try to summarize one column. (First I tried it with the little arrow on the site of the column name and after that I use SUM, nothing works)

But than I find out If I add for example to a table visual the original column (with "Don't summarize") and the Measure it works.


Have anyone a Idea why this can be happen?


Summe1 = Measure (SUM)

Betrag = Original Column


Best Kathrin

with original column with sum option.pngwith original column.png

Community Support Team
Community Support Team

Re: Datasource: Dataflow - SUM/Summarize dosen't work correctly

hi, @KBO 

It is strange, if the total value of table visual is still "0"? if the total of this column is 0 in dataset?


Best Regards,





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

Re: Datasource: Dataflow - SUM/Summarize dosen't work correctly

I know it's total weird, but you see I have in the original Column "Betrag" in every row a value. Only If I try to aggregate them with SUM for example he don't show me a value.

My Dataset based on the "New Connection" Data Flow - and in the Flow the Data is loaded correct Smiley Happy. If this was the question?


Best Kathrin

Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 169 members 1,998 guests
Please welcome our newest community members: