I'm pulling data into the MS SQL server which I then use to build a report in Power BI. I have some duplicate values that I want to remove. I know how to do it in Power BI desktop.
The problem is that the report is published to Power BI cloud and dataset is refreshed daily in the cloud.
Is there any way to remove duplicates when data is refreshed in the cloud?
Solved! Go to Solution.