How to remove duplicate rows in Direct Query

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