How to Use Tabular Editor in Power BI – A Beginner's Guide to Team Collaboration

Introduction
When we work on a Power BI project, we usually create tables, relationships, DAX measures, and dashboards.
But what happens when multiple team members work on the same project?
For example, one team member may work on patient analysis, while another works on hospital admissions.
Both team members create their own DAX measures and save their work in separate Power BI files.
At the end of the project, we need to bring their work together into one final Power BI model.
This is where Tabular Editor can help us.
In this blog, we will learn what Tabular Editor is, how to install it, how to connect it to Power BI, and how to use it to manage and consolidate DAX measures created by different team members.
We will understand the process step by step using a simple healthcare dataset.
Step 1: What Is Tabular Editor?
Tabular Editor is an external tool that works with Power BI.
It helps us manage the semantic model used by our Power BI reports.
A semantic model contains tables, columns, relationships, and DAX measures.
With Tabular Editor, we can:
Create and edit DAX measures.
Rename measures.
Organize measures into folders.
Update multiple measures at once.
Manage model properties.
Make it easier to maintain models when working in teams.
We will use Tabular Editor 2, which is free and open-source.
Step 2: Download and Install Tabular Editor
First, we need to install Tabular Editor on our computer.
1. Open the official Tabular Editor download page:
2. Find the latest version of Tabular Editor 2.
3. Under Windows installer, download the Windows installer file ending in .msi.
4. Open the downloaded installer.
5. Follow the installation instructions and click Next where required.
6. Click Install and wait for the installation to complete.
7. Click Finish.
That's it! We have installed Tabular Editor.
Tabular Editor download page

Step 3: Prepare Our Power BI Files
For this demonstration, we are using a dummy hospital healthcare dataset.
Our dataset contains two tables:
Table | Description |
Patients_data | Contains patient information |
Admissions_data | Contains hospital admission details |
We have divided the project between two team members.
Team 1 – Patient Analysis
This team created measures such as:
patient_count
avg_patient_age
male_patient_count
female_patient_count
patient_gender_percentage
Team1 Power BI file is named: Team1_Patient_Analysis.pbix
Team 2 – Admission Analysis
This team created measures such as:
admission_count
avg_length_of_stay
admitted_patient_count
avg_admissions_per_patient
department_admission_percentage
Team2 Power BI file is named: Team2_Admission_Analysis.pbix
Both files use the same two tables and relationships, but each team has created different measures.
Our goal is to bring these measures into one common Power BI model.
Two Power BI files saved in a folder.

Step 4: Open Tabular Editor from Power BI
Now let's open Tabular Editor.
Open Team1_Patient_Analysis.pbix in Power BI Desktop.
Go to the External Tools tab.

Click Tabular Editor.
Wait for Tabular Editor to open.
Tabular Editor will open and show the tables, columns, and DAX measures from the Power BI file you are currently working on.
On the left side, we can see the tables and measures from our model.
For example, expand the patients_data table to see the measures created by Team 1.
Tabular Editor displaying the patient measures

Step 5: Explore the Measures in Tabular Editor
Let's understand how Tabular Editor displays our measures.
Expand the patients table.
Select patient_count.
Look at its DAX expression.
We should see a calculation similar to this:
DISTINCTCOUNT(patients[patient_id])
We can also view the measure's name, format, description, and display folder.
Similarly, we can click other measures to review their DAX expressions.
This helps us understand what calculations have been created in our Power BI model.
patient_count and its DAX expression

Step 6: Prepare a Master Power BI File
Before combining the team measures, we need one common Power BI file.
For this example, we will use a master file containing the same two tables and relationships.
The master file should not contain the team measures yet.
Save it as: Hospital_Analytics_Master.pbix

This will be our final model.
We will bring the measures from Team 1 and Team 2 into this master file.
Step 7: Copy Team 1 Measures into the Master Model
Now let's bring the patient measures into the master model.
For this beginner demonstration, we will use Tabular Editor to copy the measures.
Close the Team 1 Power BI file after saving it.
Open Hospital_Analytics_Master.pbix in Power BI Desktop.
Go to External Tools and open Tabular Editor.
Keep this Tabular Editor window open.
Open a second Tabular Editor window.
Open the Team1_Patient_Analysis.pbix file in another Power BI Desktop window. Then go to External Tools → Tabular Editor to open the Team 1 measures in a separate Tabular Editor window.
Expand the patients_data table in the Team 1 model.
Select the five patient measures.
Copy the selected measures.
In the master model's Tabular Editor window, select the patients_data table and paste the measures.
Check that all five measures appear under the correct table.
Save the changes in the master Tabular Editor window.
The patient measures in the master model.

Step 8: Bring Team 2 Measures into the Master Model
Next, we will bring the hospital admission measures into the same master model.
Follow a similar process:
Open the Team 2 model in another Power BI Desktop instance.
Open Tabular Editor from the Team 2 file.
Expand the admissions_data table.
Select the five admission measures.
Copy the measures.
Switch to the Tabular Editor window connected to the master model.
Select the admissions_data table.
Paste the measures.
Check the names and DAX expressions.
Save the changes.
Now our master model should contain measures from both teams.
Both patient and admission measures in the master model.

Step 9: Verify the Consolidated Measures in Power BI
After copying the measures from both teams, let's check whether they are available in our master Power BI file.
Return to Hospital_Analytics_Master.pbix.
Look at the Data pane on the right side.
Under the patients_data table, we should see the five patient measures.
Under the admissions_data table, we should see the five admission measures.
Expand the patients_data and admissions_data tables.
Verify that all the measures from Team 1 and Team 2 are listed.
We can now see that the measures from both teams are available in one Power BI file.
All consolidated measures displayed in the master Power BI file.

We have successfully brought the measures from both teams into one common model!
Step 10: Copy the Team Visuals into the Master Power BI File
Now that we have copied the measures from both teams using Tabular Editor, let's bring their visuals into our master Power BI file.
Open Team1_Patient_Analysis.pbix in Power BI Desktop.
Select the Patient Distribution by Gender Donut Chart.
Press Ctrl + C to copy the visual.
Open Hospital_Analytics_Master.pbix.
Go to Report View and press Ctrl + V to paste the visual.
Similarly, open Team2_Admission_Analysis.pbix and copy the Hospital Admissions by Department Bar Chart.
Paste the chart into the master Power BI file.
Check that both visuals display correctly without any errors.
Verify that the values match those in the original Team 1 and Team 2 reports.
Save the master Power BI file.
We now have the measures and visuals from both teams in one Power BI file.
Both the Donut Chart and Bar Chart together in the master Power BI report

This completes our team consolidation process using Tabular Editor and Power BI Desktop!
Conclusion
In this blog, we learned how to install Tabular Editor and use it with Power BI Desktop.
We also learned how to copy DAX measures from different team files into one master Power BI file using Tabular Editor.
Finally, we copied the visuals from both teams into the master file and verified that everything was working correctly.
Tabular Editor makes it easier to manage DAX measures, saves time, and helps teams work together more efficiently.
Happy Reading..!!


