Overview
Tabular Editor 3 can connect to composite models that leverage DirectQuery over Analysis Services (DQ‑over‑AS), but full modeling support is not yet available. Most authoring tasks work as expected; however, operations that rely on synchronising metadata with the remote semantic model—such as Update table schema—are currently limited.
Important
Until full DQ‑over‑AS support ships, model metadata edited in Tabular Editor 3 is not automatically kept in sync with the source dataset. You must apply one of the work‑arounds listed below whenever columns or measures are added to the underlying Analysis Services model.
Current limitations
| Feature | Status in TE3 | Notes |
|---|---|---|
| Update table schema | ❌ Not supported | Attempting to run Model > Update table schema on a DQ‑over‑AS table has no effect. |
| Measure synchronisation | ❌ Not supported | Measures created in the source dataset do not appear automatically in the composite model. |
Work‑arounds
1. Manually add missing columns
In TOM Explorer, select the table that requires the new column.
Choose Add > Data Column.
In the Properties window, set:
- SourceColumnName – exactly match the Name of the column in the remote table.
- SourceLineageTag – copy the LineageTag value from the source column.
Save and deploy the model.
Note
Column names and lineage tags must match character‑for‑character. Any mismatch will cause deployment errors.
2. Use the “Import tables from remote model” C# script
Daniel Otykier’s article on LinkedIn provides a ready‑made C# automation script that:
- Temporarily imports full copies of tables from the remote model.
- Lets you copy columns (and other metadata) into existing tables.
- Deletes the temporary tables after the copy is complete.
This approach is faster when several tables require updates.
3. One‑click macro to pull new measures
rem-bou's GitHub repository contains an advanced macro that scans the source dataset for measures that are missing in the composite model and adds them automatically: Create-Update DQ over AS model connection