How to remove duplicate rows in Direct Query

[Divya904]

Hi Experts,

I have duplicated a query/table in Power BI - Edit queries option. Now i need to remove the duplicates in one column from duplicated query. When i am trying to do so, it gives me following error:

"This step results in a query that is not Supported in DirectQuery mode"

Please advise if there is any trick/method to remove duplicate  rows in Direct Query Mode.

Thanks

[v-cherch-msft · Accepted solution]

Hi @Divya904

You may refer to the below post.

https://community.powerbi.com/t5/Desktop/Remove-duplicates-in-direct-query/td-p/238430

Regards,

Cherie