Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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,
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |