search

TabularEditor / TabularEditor3

Bug reports, feature requests, discussion and documentation for Tabular Editor 3 (commercial version).
61 stars 7 forks source link

Composite model not able to get updated column #1203

Closed VinothiniRaj closed 5 months ago

VinothiniRaj commented 5 months ago

Description

Hi Team

In my composite model, I have connected these two data models.

tmp_9b455855-bdd6-4f1e-b389-a4b6f83e61b0 tmp_92c36f25-1ed3-4737-abf5-6032a6d48db4

I have added EntitycodeID column in the first model. But am not able to get this column in composite model.

tmp_b8b195ae-9dc2-4cd8-bcda-fdbec5ab3016 tmp_303ab908-e994-4575-9d18-1a6955e649db

Tabular Editor 3 Version

3.12.1

Screenshots

No response

Steps to Reproduce

No response

Expected behavior

No response

Crash Report

No response

Windows Version

Windows 10 Pro

otykier commented 5 months ago

Hi @VinothiniRaj Unfortunately, we do not yet have full support for DQ over AS models in Tabular Editor. For this reason, you will see that the "Update table schema" feature won't work. We're working on adding full support for this, and will provide you with an update once we have something to share.

In the mean time, you will have to work around this limitation by manually adding the column on the DQ over AS model, i.e. add a Data Column to the table, then fill out the "SourceColumnName" property to match the "Name" property of the source column, and set the "SourceLineageTag" property to match the "LineageTag" of the source column.

I also wrote an article with a C# script a while ago to help automate the process of importing tables from a remote model into a DQ over AS composite model. This may also help you in this case, as you could run the script to temporarily import a full copy of the tables that are missing columns, then copy over the columns that you need into the existing tables, and finally delete the temporary tables (created by the script).