Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!