Dataset missing expression
Published 04 July 2025
A dataset is defined as an expression dataset but no expression is defined.
How to fix
Ensure that the dataset has a valid expression or remove the dataset.
Problem example:
{
"tables": [
{
"schema": "Person",
"name": "Address",
"columns": [
{
"name": "Email",
"dataset": "EmailAddresses",
"deterministic": true
}
],
"datasets": [
{
"name": "EmailAddresses",
"type": "Expression"
// Missing "expression" property
}
]
}
]
}Ensure that the dataset has a valid expression or remove the dataset:
Option 1 - Add expression:
{
"tables": [
{
"schema": "Person",
"name": "Address",
"columns": [
{
"name": "Email",
"dataset": "EmailAddresses",
"deterministic": true
}
],
"datasets": [
{
"name": "EmailAddresses",
"type": "Expression",
"expression": "$(GivenNames($[GivenName])).$(FamilyNames($[FamilyName]))@$(Domains($[Id]))$(TopLevelDomains($[Id]))"
}
]
}
]
}Option 2 - Remove the dataset:
{
"tables": [
{
"schema": "Person",
"name": "Address",
"columns": [
{
"name": "Email",
"dataset": "SomeOtherDataset"
}
]
}
]
}