Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.