Data not populating in the report

[neelofarshama]

Hi,

I have an import query report for which data populating is wrong. When I filter for a single voucher there sgould be 4 records but in the report only one record is populating as shown below.

In the query editor also there are 4 records, with amount showing 55 but it repoirt the amount is 0 and only one record is displayed.

Please suggest whats wrong in the report.

Thanks In Advance,

Neelofar Shama.

[amitchandak · Accepted solution]

@neelofarshama , Amount will by default a sum, So rows are getting group. Even if you make un summarized, you will only get 2 rows. grouped/distinct

You can add an index in power query and use that in table visual - https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi (un summarized )