API Dataset - Filter duplicate rows

[donbesada]

Hi,

I have a dataset which is populated from Rest API. It basically reports  transaction time in minutes each month and displays the average.

Issue currently I have is for some months, I have duplicated rows for a particular month entry.

As per screenshot, I display 3 values ( 11 for August / 49 for September / 49 for October), therefore average should be 36.33

However, I have duplicate values for August month so PowerBi counts 11 + 11 for August + 49 for September + 49 for October / 4 = 30 minutes.

Is there any way to remove/filter the duplicate value for a row ? I've tried using DISTINCT function but couldn't get it working.

Thanks

[v-shex-msft]

HI @donbesada,

You can try to use power query to filter duplicate records.

>> I've tried using DISTINCT function but couldn't get it working.

DISTINCT function will remove records which every columns has the similar value(e.g. row1[column1] =row2[column1], row1[column2]=row2[column2]... keep one of them)

Regards,

Xiaoxin Sheng

[donbesada · Accepted solution]

Hi @v-shex-msft,

Thanks for the inputs.

Unfortunately, the Query Editor is greyed out when the data source is a PowerBi Service dataset:

Hopefully, the feature to update/delete individual rows on a Service dataset will be available soon: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9366600-update-rows-rest-api

Regards