Composite model not able to get updated column #1207
DescriptionHi Team In my composite model, I have connected these two data models. 
I have added EntitycodeID column in the first model. Tabular Editor 3 Version3.12.1 ScreenshotsNo response Steps to ReproduceNo response Expected behaviorNo response Crash ReportNo response Windows VersionWindows 10 Pro |
Replies: 1 comment
|
Hi @VinothiniRaj 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). |
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…