Remove duplicates

The objective of this example is to prevent refresh failures due to duplicate source values in the relationship column of a dimension table. Additionally, the duplicates are to be isolated for further inspection and troubleshooting:

  1. Access a dimension table query from an unstructured data source such as an Excel Workbook.
Figure 71: Product Query Preview
  • The source is an Excel table maintained by business users.
Figure 72: Excel Data Source
  • The Product Name column is used for the relationship to the Sales fact table; ...

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial