All 35 lessons
Start here: cloud, data, Fabric and Power BI basics
- 1. Start here: the exam, the plan and what you already know
- 2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits
- 3. Data basics: files, tables, formats and the lakehouse idea
- 4. A tour of Microsoft Fabric: OneLake, workspaces and items
- 5. Power BI in plain words: semantic models, reports and DAX
Prepare data: get data in (exam area 2, 45-50%)
- 6. Connect to data and find it: connections, gateways, OneLake catalog and Real-Time hub
- 7. Choosing a data store: lakehouse, warehouse or eventhouse
- 8. Use data without copying: shortcuts, mirroring and OneLake integration
- 9. Ingest data: Dataflow Gen2, pipelines, Copy job and notebooks
- 10. Power Query in Dataflow Gen2: filter, data types, merge and new columns
- 11. Messy data: duplicates, missing values and nulls
Prepare data: transform and query (exam area 2)
Design and build semantic models (exam area 3, 25-30%)
- 18. Choose a storage mode: Import, DirectQuery, Direct Lake and Dual
- 19. Relationships: star schemas, bridge tables and many-to-many
- 20. DAX foundations: measures, filter context, CALCULATE and variables
- 21. DAX functions the exam tests: iterators, table filters, windows and information functions
- 22. Calculation groups, dynamic format strings and field parameters
- 23. Composite models and large semantic model storage format
Optimize models, then secure them (exam areas 3 and 1)
- 24. Direct Lake in depth: fallback, refresh and the two flavors
- 25. Incremental refresh for semantic models
- 26. Faster reports and DAX: finding and fixing slow queries
- 27. Who can see what: workspace roles and item permissions
- 28. Fine-grained security: rows, columns, objects and files
- 29. Governance: sensitivity labels and endorsement
Lifecycle, then exam practice (exam area 1)
15 min
Governance: sensitivity labels and endorsement
Apply sensitivity labels to Fabric items and endorse trusted items.
By the end of this lesson you can
- Apply a sensitivity label and predict where it flows
- Choose between Promoted, Certified and Master data for an item
- Name who can apply each badge and each label
- Tell a governance need from a security need
From earlier lessons · 1 of 2
A Juniper manager has the Contributor role and sits in a dynamic RLS role. Why does she see every region?
Pick one answer.
From earlier lessons · 2 of 2
Which feature hides a whole column, and its name, from a semantic model role?
Pick one answer.
An auditor visits Juniper Coffee. She asks which Fabric items hold loyalty members' personal data, and how anyone would know. Meanwhile, finance has built reports on three different sales models. Nobody can say which one is right. Last lesson you controlled who sees which rows. This lesson you tell people what each item is.
Sensitivity labels: how sensitive is this item?
Exam depth: know it cold.
A sensitivity label is a tag on an item that says how sensitive its data is, such as General or Confidential.
Labels come from Microsoft Purview Information Protection, Microsoft's compliance service. Your security team creates and publishes them there. Fabric only applies them.
To apply a label you need:
- A Power BI Pro or Premium Per User (PPU) license.
- Edit permission on the item.
- The label published to you in Purview. Otherwise it shows greyed out.
Apply it in one of two places. Select the sensitivity indicator in the item's header, or open the item's settings and use the sensitivity section.
A label on its own is information. It controls access only when the security team links it to a Purview protection policy. Then the policy decides who can open the item.
Labels also travel with data in some exports:
- Export to Excel, PDF or PowerPoint.
- Analyze in Excel.
- Download of a .pbix file.
Export to .csv or .txt carries no label and no protection.
Inheritance: labels flow downstream
Exam depth: know it cold.
Label inheritance means a label copies itself to related items, so you don't label each one by hand.
- On creation. A report built on a labeled semantic model gets the model's label. So does a Notebook created from a labeled Lakehouse.
- Downstream. Change the label on a parent, and its existing reports and dashboards follow.
- From data sources. An Import model on a labeled Azure SQL Database inherits that label on refresh.
The tenant setting Automatically apply sensitivity labels to downstream content makes downstream inheritance fully automatic. It's on by default. When it's off, the user ticks a consent checkbox instead.
You are an analytics engineer at Juniper Coffee. The sales semantic model is labeled Confidential. Twelve reports inherited that label. An analyst set one report to General by hand. You change the model to Highly Confidential, with fully automated inheritance on. Which reports change?
Pick one answer.
Exam depth: recognize it.
A Fabric admin controls labels in the Information protection tenant settings: OneLake catalog > Govern > Configurations > Tenant settings.
| Setting or policy | What it does |
|---|---|
| Allow users to apply sensitivity labels for content. | Turns labels on, for everyone or chosen groups. |
| Apply sensitivity labels from data sources to their data in Power BI. | Turns on inheritance from data sources. |
| Automatically apply sensitivity labels to downstream content. | Fully automated downstream inheritance. |
| Default label (Purview policy). | New or edited items get a label automatically. |
| Mandatory label (Purview policy). | Users can't save without a label. Fully supported for Power BI items only. |
Endorsement: Promoted, Certified, Master data
Exam depth: know it cold.
Endorsement puts a badge on an item so people can find content they can trust.
| Badge | What it means | Who can apply it |
|---|---|---|
| Promoted. | The creator thinks it's ready to share and reuse. | Anyone with write permission on the item. |
| Certified. | It meets the organization's quality bar. | Reviewers the Fabric admin authorizes, with write permission. |
| Master data. | Core, single-source-of-truth data, like a product list. | Users the Fabric admin authorizes, with write permission. |
You can promote or certify any item except Power BI dashboards. Master data fits only items that hold data, such as a Lakehouse or semantic model.
Decision rule: the creator's own signal is Promoted, an official review is Certified, and the one reference copy is Master data.
Certified and Master data work only after a Fabric admin turns them on:
- Certification tenant setting: the admin lists security groups of certifiers. Named users aren't accepted. The admin can let domain admins set their own certifiers.
- Endorse master data (preview) tenant setting: the admin picks the whole organization or chosen security groups.
Not authorized? In the item's settings the Certified or Master data button is greyed out. Select How do I get content certified to request it.
When you promote or certify a semantic model, a Make discoverable box may appear. It lets people without access find the model and request access.
Match
Match each Juniper Coffee item to the badge it should get
Pick an item on the left, then its match on the right.
Label, badge or security? Three different questions
Exam depth: know it cold.
| Sensitivity label | Endorsement | RLS, OLS, roles | |
|---|---|---|---|
| Answers. | How sensitive is it? | Can I trust it? | Who may see it? |
| Comes from. | Microsoft Purview. | Fabric. | Fabric and the model. |
| Spreads to other items. | Yes, by inheritance. | No. | No. |
| Controls access. | Only with a protection policy. | No. | Yes. |
An item can carry all three. The sales model might be Confidential, Certified and secured with RLS.
The OneLake catalog shows the first two: its items list has an Endorsement column and a Sensitivity column.
Decision rule: flag data, use a label. Point people to trusted data, use a badge. Restrict data, use security.
Try it in Fabric
Labels appear only if your organization publishes them in Purview. Promotion works on any trial.
Apply a label
- Open a semantic model or Lakehouse in your workspace.
- Select the sensitivity indicator in the item header.
- In the flyout, pick a label from Sensitivity.
Promote the item
- Open the item's settings.
- Expand the endorsement section, select Promoted, then Apply.
- Open the OneLake catalog. Select the Endorsed items filter and find your item.
Exam-style practice
You are an analytics engineer at Juniper Coffee. Only the data office may mark items as meeting company quality standards. You have write permission on the sales semantic model but aren't in the data office's security group. You need the model to carry that mark. What should you do?
Pick one answer.
You are an analytics engineer at Juniper Coffee. Several teams keep their own lists of products and prices. Leadership names one Lakehouse as the authoritative product list for the whole company. You need people to recognize it as that. Which badge fits?
Pick one answer.
You are an analytics engineer at Juniper Coffee. The loyalty semantic model holds members' personal data. Every report anyone builds on it must be flagged as sensitive, with the least manual effort. What should you do?
Pick one answer.
Worth keeping
- Sensitivity labels come from Microsoft Purview; you apply them with edit permission.
- Labels flow to new and downstream items, but never overwrite a manual or stricter label.
- Promoted needs write permission; Certified and Master data need an admin-authorized user.
- Labels flag data, badges point to trusted data, and security restricts it.
On the job
Back to the auditor at Juniper Coffee. You label the loyalty model Confidential. Every report on it picks up the label. When she asks which items hold personal data, the answer is a filter in the catalog.
Next, the three sales models. You agree with finance which one is right. You promote it and request certification from the data office. Once it's certified, new finance reports use it, and the other two copies are retired.
Each month you open the catalog's Govern tab and check label coverage. Unlabeled items go on your to-do list.
Your items are secured, labeled and badged. Then someone edits a certified measure directly in production and breaks every finance report. Next lesson: version control with Git and Power BI projects.
Leaderboard
Loading…
50 XP for each lesson you finish, 10 for each right answer. Names show only for learners who turn on Show me on leaderboards.
Sources for this lesson (14)
Each fact in the lesson is marked with the number of the page it comes from.
- [6]Microsoft Learn: Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
- [73]Microsoft Learn: Find and explore data in the OneLake catalog
- [75]Microsoft Learn: Govern and manage your Fabric data estate with the OneLake catalog
- [209]Microsoft Learn: Row-level security (RLS) with Power BI
- [279]Microsoft Learn: Object-level security (OLS)
- [284]Microsoft Learn: Apply sensitivity labels to Fabric items
- [285]Microsoft Learn: Enable item certification
- [286]Microsoft Learn: Enable master data endorsement
- [287]Microsoft Learn: Endorsement overview
- [288]Microsoft Learn: Endorse Fabric and Power BI items
- [289]Microsoft Learn: Information protection tenant settings
- [290]Microsoft Learn: Information protection in Microsoft Fabric
- [291]Microsoft Learn: Sensitivity label downstream inheritance
- [292]Microsoft Learn: Sensitivity label inheritance from data sources