Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I keep getting the below error when refreshing the data. However, when I look at the table in Power Query, the whole column is unique. The database that I am pulling from is also saying there is no duplicate record. Does anyone know how to fix this please?
contact
Solved! Go to Solution.
Hello @JLYT. In power query editor, right click on the column (_id), and remove duplicates. To be on the safe side, after that click on Remove Errors. Ensure that you have these options enabled as they can help you identify unique/error values. Hope it helps!
Hello @JLYT. In power query editor, right click on the column (_id), and remove duplicates. To be on the safe side, after that click on Remove Errors. Ensure that you have these options enabled as they can help you identify unique/error values. Hope it helps!
In Power Query, right click the _id column and deduplicate. It should fix your issue.
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |