Remove Duplicates works in desktop but not after published to service

[nrowey]

I have sorted decending my datetime column and then do a remove duplicates based on two rows.

It works fine on the PBI Desktop but is not working after published ... How can that be ????

Controls:

Sort------ Table.Buffer(Table.Sort(#"Filtered Rows1",{{"rowlastupdated", Order.Descending}}))

Remove Duplicate ------Table.Distinct(#"Sorted Rows", {"accountingaccount", "dealno"})

Lost on tjhis one...?

[Anonymous · Accepted solution]

Hi @nrowey ,

Unfortunately, I did a simple test, but failed to be able to reproduce your problem. You can see the results of my test below：

By the way , Have you ever applied the actions in Power Query before publishing to Power BI Service?

Please try publishing to Power BI Service again and if this issue exists, please provide more details so that we can better troubleshoot the issue.

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @nrowey ,

Unfortunately, I did a simple test, but failed to be able to reproduce your problem. You can see the results of my test below：

By the way , Have you ever applied the actions in Power Query before publishing to Power BI Service?

Please try publishing to Power BI Service again and if this issue exists, please provide more details so that we can better troubleshoot the issue.

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[nrowey · Accepted solution]

I dont understand why applied action in Power Query worked  or what differance is makes, it sounds like it just saves it..   I am confused , but thankyou I would have never gotton there without your help....