Fact Load Strategy selected (Business Rule)
Applies to
Platform: Microsoft SQL Server · Snowflake · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle
Architecture: Dimensional · Data Mart
This business rule checks that every dataflow of a Fact or Mart Fact has a Fact Load Strategy selected. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10026.
Message
The client shows an error with this text on the model object. <model object name> and <type> stand for its name and type.
Model object '<model object name>' of type '<type>' has has no option for property FactLoadStrategy selected. At least one value has to be selected.
On the model object card, point to the error icon to see this message with the rule ID: Error ID-10026. The Generate Artifacts page lists the message without the ID.

Cause
A dataflow of the Fact or Mart Fact has no value selected in Fact Load Strategy.
Fix
- Open Edit Dataflow for the dataflow, see Edit a Dataflow.
- Select
Truncate InsertorInsertin Fact Load Strategy and save. The error disappears.
Check the result
The error icon is gone from the model object, and generation is no longer blocked by it.
Example
In a Data Mart project on Microsoft SQL Server, the Fact Load Strategy of the Mart Fact deduplication_partition_mart_fact is cleared. The client shows:
Model object 'deduplication_partition_mart_fact' of type 'Mart Fact' has has no option for property FactLoadStrategy selected. At least one value has to be selected.
Related articles
- Reference: Fact Load Strategy (Dataflow)
- See also: Edit a Dataflow, One Fact Load Strategy selected (Business Rule), Understand warnings and errors