Solved: How to remove duplicate rows in Direct Query

Divya904 · ‎08-28-2018

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 · ‎08-29-2018

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.