Error when importing AX Retail Channel Performance PowerBI pack

Symptoms

When attemp to import Microsoft Dynamics AX Retail Channel Performance pack in PowerBI it fails with the error message below:

 

Column 'OrganizationNumber' in Table 'Default Retail Organization Hierarchy' contains a duplicate value '000161090' 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.

Resolution

Considering date effectiveness in the Defaul Retail Organization Hierarchy Entity to retrieve just valid records, avoiding duplicated entries.

More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Propriedades

ID do Artigo: 4012109 - Última Revisão: 02/02/2017 - Revisão: 1

Comentários