Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
campelliann
Post Patron
Post Patron

PowerBI Service throwing Duplicate error

Hi there,


PowerBIservice keeps failing the schedule refresh with the below error, although we dont have any duplicates on the table. After clearing the cache it seemed the issue was resolved, but then it came back. 

Any ideas?

 

 

 

Column '<ccon>Id</ccon>' in Table '<ccon>Tickets</ccon>' contains a duplicate value '<ccon>2016</ccon>' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

2 REPLIES 2
Sahir_Maharaj
Super User
Super User

Hello @campelliann,

 

Here are some steps you can take to address this issue:

  1. Verify the data: Double-check the data in the 'Id' column of the 'Tickets' table. Ensure that there are no duplicates or conflicting values. Look for any inconsistencies or discrepancies that might be causing the error.

  2. Check relationships: Examine the relationships between the 'Tickets' table and other tables in your data model. Confirm that the 'Id' column is correctly used as the foreign key in any many-to-one relationships. If the 'Id' column is involved in relationships, ensure that the relationships are defined correctly and that the data aligns with the relationship requirements.

  3. Check primary key constraints: If the 'Id' column is used as the primary key in the 'Tickets' table, ensure that there are no duplicate values in the column. Additionally, verify that the primary key constraints are properly set in your database.

  4. Clear cache and refresh: Since clearing the cache temporarily resolved the issue, try clearing the cache again and then refresh the data. Sometimes, cached data or artifacts can cause conflicts, so clearing the cache can help refresh the data and potentially resolve the error.

  5. Check data source: If you are connecting to an external data source, such as a database, make sure that the data in the source itself does not contain any duplicates in the 'Id' column. Verify the integrity of the data directly in the data source to rule out any issues from the source itself.

  6. Rebuild relationships: In case the issue persists, consider rebuilding the relationships between tables from scratch. Remove all existing relationships and recreate them based on the correct column mappings and cardinality.

  7. Split the query: If you are loading data using a complex query or multiple tables, consider splitting the query or loading the data in stages. This approach can help identify which specific part of the query or table is causing the issue. You can then isolate and resolve the problem area.

Let me know if you might need further assistance.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Hi there, Thank you for your detailed answer. Could incremental refresh be the cause? At least the problem started with it...

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.