Forum Discussion
How to Transfer DAX Measures, Calculated Columns, and Relationships Between Two Power BI Datasets
Tabular Editor is generally safe from a data-security perspective when used normally. It works primarily with model metadata, not the underlying data.
Power_Be_Eye some other optons you can consider too..
ALM toolkit.
This tool compares two datasets and lets you:
See differences
Select what to deploy between them
Push only measures / relationships / columns
Again, requires XMLA endpoint.
Lastly, TMDL view.
If you're using the newer model format:
Open the source PBIX
Go to TMDL View
Copy the model definition files
Paste into the target model
Sharing for reference , HTH.
You can use TMDL
Paste that into the TMDL view of the other dataset. This will overwrite existing tables and columns and create any new ones that don’t yet exist. Before clicking Apply, remove all lineage tag lines. For calculated columns and measures that exist in the source but not in the target dataset, those will be removed so handling them will require a fairly manual process.
Thanks for the detailed explanation — that helps a lot!
I have one more question regarding Tabular Editor.
Is it considered safe to use from a data‑security perspective?
Specifically:
- Does Tabular Editor access or extract any of the underlying data from the dataset, or does it only interact with the metadata (model, measures, relationships, etc.)?
- Does any information get sent outside my environment, or is everything handled locally when connected via XMLA?
Just want to make sure it’s secure before using it in a production workspace.
Thanks!
Super UserTabular Editor is generally safe from a data-security perspective when used normally. It works primarily with model metadata, not the underlying data.