Skip to main content

How to Create a Semantic Model Without a Report in Power BI

· 5 min read
Jagdish Kumawat
Founder @ Dewiride

When you get data in the Power BI service, the last step offers two ways out: Create a report or Create a semantic model only. The second saves the model and opens it in the model editor, so you can add relationships, measures and row-level security before anyone builds a report on it. Here's how.

Microsoft's Edit semantic models in the Power BI service says Create a semantic model only creates just the semantic model, without launching the report editor, and calls it ideal if you want to refine your semantic model, add relationships, create DAX measures, or configure row-level security before building reports. The example finishes three shaped queries, Expenses, Expense Categories and Category managers, into a model called Expenses (How to Get Data from a SharePoint List in Power BI in the Browser).

Step 1: Choose Create a Semantic Model Only​

At the bottom right of Power Query, the green button reads Create a report. Select the arrow beside it and choose Create a semantic model only:

The arrow beside the Create a report button opened, offering Create a report and Create a semantic model only, which is outlined in red, next to a Cancel button

Step 2: Name the Model and Pick Its Workspace​

The Create new semantic model dialog lists My workspace and your workspaces. The workspace you started from is selected, here How-to Examples. Type the Semantic model name, here Expenses, and select Create:

The Create new semantic model dialog with My workspace, How-to Examples selected and Overtime Timesheet on the left, the empty How-to Examples folder on the right, the Semantic model name Expenses, and the Create and Cancel buttons

Step 3: Check the Model​

Power BI loads the data and opens the model editor in Model view, with a card for each table and its columns:

The model view with three table cards: Expense Categories with Title, Category managers with ManagerEmail and Title, and Expenses with Amount, Category, Expense, ExpenseDate and SubmitterEmail, and a relationship line marked 1 and * between Expense Categories and Category managers

Power BI had already added a relationship between Expense Categories and Category managers, through their Title columns, but none to Expenses. Always check relationships Power BI made for you, and add the ones it missed (How to Create a Relationship Between Two Tables in Power BI).

Changes in the model editor save automatically. The model now appears in the workspace, ready for measures (How to Create a Measure in Power BI in the Browser) and a report (How to Create a Report from a Semantic Model in Power BI).

Common Mistakes​

MistakeWhat happensDo this instead
Selecting the green button itselfPower BI opens the report editor at onceThe arrow, then Create a semantic model only
Saving to My workspace by habitNobody else can use the modelThe shared workspace
Trusting the automatic relationshipsA relationship can join the wrong columnsCheck each one, and add the missing ones

Troubleshooting​

SymptomLikely causeFix
A table is missing from the modelIts query had Enable load offTurn it on in Power Query and update the model
A column has the wrong typeIts type wasn't set in Power QuerySet it in Power Query or in the model's Properties
A relationship line joins unexpected columnsPower Query's names matched by chanceEdit or delete it in Manage relationships

FAQ​

Can I go back to Power Query later?​

Yes. In the model editor, Transform data opens Power Query with the model's queries, as Microsoft's article describes.

Is there an undo?​

No. The same article says changes are saved automatically and are permanent with no option to undo. It mentions the semantic model's version history for recovering the model to an earlier point.

Does the model refresh by itself?​

Not until you schedule it (How to Schedule a Refresh of a Power BI Semantic Model).

Conclusion​

In Power Query, select the arrow beside Create a report, then Create a semantic model only, name the model and pick the workspace. Power BI saves it and opens the model editor; the example's Expenses model had three tables and one automatic relationship to check.

Additional Resources​