marclelijveld / External-Tools-Model-Documentation

This repository includes everything that is needed in order to run the External Tools capability in Power BI Desktop and generate Model Documentation.
https://data-marc.com/model-documenter/
MIT License
110 stars 42 forks source link

PBI Documenter error message - Column [<myName>] is part of composite key #43

Closed sherlockspreadsheets closed 2 years ago

sherlockspreadsheets commented 2 years ago

Getting an error message when running the PBI Documenter tool for one of our reports. This particular error message relates to the new field parameter feature, which we have implemented in the report.

What is causing this error? How can I correct this so that PBI Documenter tool can be executed successfully?

Query (41, 87) Column [Dynamic VALUES] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression. Error 0x0003: Error exporting vpax file.

image


PBI Desktop

Here is some information concerning the DAX table with documentation errors.

'Dynamic VALUES' := 
{
    ("Disposal (groups)", NAMEOF('Disposal'[Disposal (groups)]), 0),
    ("Company (clean)", NAMEOF('Company'[Company (clean)]), 1),
    ("Operator (clean)", NAMEOF('Operator'[Operator (clean)]), 2),
    ("Hauler (clean)", NAMEOF('Hauler'[Hauler (clean)]), 3),
    ("Meter", NAMEOF('Meters Isometry'[Meter]), 4),
    ("Disposal (unified_name)", NAMEOF('Disposal'[Disposal (unified_name)]), 5),
    ("Company (unified_name)", NAMEOF('Company'[Company (company_unified_name)]), 6),
    ("Operator (unified_name)", NAMEOF('Operator'[Operator (company_unified_name)]), 7),
    ("Hauler (unified_name)", NAMEOF('Hauler'[Hauler (company_unified_name)]), 8),
    ("Business Entity", NAMEOF('Piped Trucked Volume'[business_entity]), 9),
    ("Gathering Type", NAMEOF('Piped Trucked Volume'[gathering_type]), 10),
    ("BWM Entity", NAMEOF('Disposal Attributes (calc field)'[BWM Entity]), 11),
    ("BWM Company", NAMEOF('Disposal Attributes (calc field)'[BWM Company]), 12),
    ("Tie In Type", NAMEOF('Meters Isometry'[Tie In Type]), 13)
}

image

image

image

sherlockspreadsheets commented 2 years ago

I just realized this is the same issue as: Issue https://github.com/marclelijveld/External-Tools-Model-Documentation/issues/39

marclelijveld commented 2 years ago

Closed issue as it is duplicate with #39