How to Remove duplicates in direct query?

Hi,

I am a PowerBI begginer and lot of this stuff is still new for me. Please suggest me a solution for the following issue. Thanks in Advance.

I initially had two tables that I merged into one in a direct query connection. This created a lot of duplicates for some reason and when I try to remove the duplicate rows ( option present in the Query Editor menu) it gives the following message,

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

How do I still stay in the DirectQuery mode and still remove the duplicate rows?

Thanks again