Duplicate Values

Hi   aleggore ,

Can't tell without seeing your query or data. Maybe you're expecting an inner join but used another join type?

"There are no duplicate values showing when I run my query independently or in Power Query before I load to PowerBI. "

The query editor only loads the first 1,000 records by default. You can force it to load all, then you'll get the error in the editor before closing.

you can test for duplicates

= Table.IsDistinct( table )

= Table.IsDistinct( table, { "pk_column1", "pk_column2" } )

or remove duplicates.

= Table.Distinct( table )

= Table.Distinct( table, { "pk_column1", "pk_column2" } ) 

It might have to do with Power BI's case-insensitivity:Power BI And Case Sensitivity 

For testing, you could add an index column (in Power Query) to check how the affected rows look like before and after loading.

If it doesn't help, please provide more details with the error.

 Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aleggore