Forum Discussion

KasperJ90's avatar
KasperJ90
Helper III
3 years ago

Query (SUMMARIZECOLUMNS) does not include all rows from table

Hi,

 

I am using below query in a dataset to receive all rows from Table 1. I save it in a CSV file via Power Automate as historical data. The problem is, that my CSV file does not contain all rows from Table1. Should I use another formula than SUMMARIZECOLUMNS? 

 

Query:

DEFINE VAR __DS0Core =
SUMMARIZECOLUMNS(
'Table1'[Document No.],
'Table1'[Customer],
'Table1'[Qty],

EVALUATE
__DS0Core

 

Need Help

1 Reply

  • Arul's avatar
    Arul
    Super User
    3 years ago

    KasperJ90 ,

    Could you provide the existing table screenshot and also the below info as well?

    1. Existing table row count?
    2. Expected row count?

    3. Result row count?

    Thanks,