Exam DP-500 topic 1 question 78 discussion

Actual exam question from Microsoft's DP-500

Question #: 78
Topic #: 1

DRAG DROP -
You have a Power BI dataset that contains two tables named Table1 and Table2. The dataset is used by one report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Show Suggested Answer

Suggested Answer:

by Ramiel at Dec. 23, 2022, 12:42 p.m.

Comments

Submit Cancel

jeroen12345

Highly Voted 2 years, 6 months ago

1. Create Role 2. Open TE 3. Set table to Read 4. Set Column to None

upvoted 18 times

Maazi

2 years, 6 months ago

I agree with these steps. Ref: https://www.fourmoo.com/2021/03/02/configure-ols-in-power-bi-using-tabular-editor-to-limit-access-to-non-financial-measures/

upvoted 3 times

...

Fer079

2 years, 4 months ago

I agree with you. We can see a good example in this video: https://www.youtube.com/watch?v=PAX5GP9SkTA

upvoted 3 times

...

Eltooth

Most Recent 2 years ago

From jeroen12345: 1. Create Role 2. Open TE 3. Set table to Read 4. Set Column to None

upvoted 1 times

...

DarioReymago

2 years, 2 months ago

PBI: Create Role PBI: filter role TE open TE: set col to none

upvoted 1 times

...

solref

2 years, 3 months ago

The Answer it is ok, I only disagree with the order link: https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-ols?tabs=column 1. Create the role 2. Add a DAX Filter to the PM Role 3. Open Tabular Editor 4. OLS -> Set Column to None (It allows PM see the table, but not the specific columns required)

upvoted 2 times

Lolus

1 year, 10 months ago

I agree with solref and DarioReymago. Create the Role Filter the role Open Tabular Editor Set Budget and Forecast column to none.

upvoted 1 times

...

Ramiel

2 years, 6 months ago

I would replace, Tabular Editor with Dax Studio in the given answer.

upvoted 1 times

BigEd

2 years, 6 months ago

It won't be DAX Studio as you can only implement (OLS) through Tabular Editor

upvoted 4 times

...