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 am finding duplicate values in my dataset after I try to refresh. There are no duplicate values showing when I run my query independently or in Power Query before I load to PowerBI. Has anyone seen this happen before and know of any resolution?
Solved! Go to Solution.
power query doesnt load all the data since its just load a sample data for you to see the tranformation you doing, when you apply the query power bi desktop does pull all the data from the source, so probably there its some duplicate on the source data, or a tranformation you applying its generating the duplicate (this can be the case happends frenquently over merge or append steps)
Proud to be a Super User!
Hi @aleggore ,
Please check if your steps include the following.
I created the file containing the duplicate data for testing and after importing it, the duplicates did not disappear, you can use my file for testing.
Best Regards
Lucien
power query doesnt load all the data since its just load a sample data for you to see the tranformation you doing, when you apply the query power bi desktop does pull all the data from the source, so probably there its some duplicate on the source data, or a tranformation you applying its generating the duplicate (this can be the case happends frenquently over merge or append steps)
Proud to be a Super User!
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.