Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
We're importing data and I wasn't aware that the queries we added in Power BI desktop are retained when the dataset is refreshed in the cloud.
Thanks!