Forum Discussion
How to find SourceLineageTag withim project file?
- 10 months ago
Hi jaryszek,
You’re right that ChangedProperty = Name is used to track renamed objects so Power BI recognizes the column or table as the same entity after schema changes. When updating the expressionSource, there’s no need to add another ChangedProperty entry. The expression or query is managed by its own source or expression property in the TMDL file, so using ChangedProperty = Name for renamed elements is enough.
If you’re working with a Direct Lake or composite model, ensure the sourceLineageTag accurately references the updated table or field in your Lakehouse or Warehouse. This helps Power BI bind the renamed fields correctly and prevents them from being reset or dropped after a schema refresh. Only the Name property needs the change-tracking flag; other updates like expression changes are automatically managed during model sync.
Thank you.
Hi jaryszek,
This issue typically occurs when renamed columns lose their connection to the original data source, which is managed by the SourceLineageTag property in the model definition. You can locate this tag in your semantic model’s TMDL (Tabular Model Definition Language) view. In Power BI Desktop, open the TMDL view and expand the renamed table or column. You’ll find script lines like lineageTag: and sourceLineageTag:, with the latter linking the model column to the source field.
If your report is saved as a Power BI Project (.pbip), you can also open the file at YourProject.SemanticModel/definition/model.tmdl (or within the relevant table folder) and search for sourceLineageTag. Make sure this tag matches the renamed source column.
Updating the SourceLineageTag to reflect the new name allows Power BI to identify the object as the same source field during schema refresh, preventing it from being deleted or reset. This tag maintains the relationship between renamed fields in your model and the original source columns, ensuring your TE (Tabular Editor) changes remain after refreshing Direct Lake or reopening the model in Power BI Desktop.
Lineage tags for Power BI semantic models | Microsoft Learn
Use Tabular Model Definition Language (TMDL) view in Power BI Desktop - Power BI | Microsoft Learn
Power BI Desktop projects (PBIP) - Power BI | Microsoft Learn
Thank you.