Forum Discussion

rnola16's avatar
rnola16
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Unable to change Parameters in Workspace semantics.

Hi all,   I have a semantic model that uses parameters on a report that is published to a workspace. As an admin I'm able to make changes on the parameter values and run them. I'd like to have user...
Need Help
  • rnola16's avatar
    rnola16
    1 year ago

    Was able to configure the reason in the M code. Able to work it out with Mass Filter.

nandic's avatar
nandic
Icon for Resident Rockstar rankResident Rockstar
1 year ago

rnola16 
The user who published the latest version of semantic model to Power BI Service is the "owner" of it.
Only this user can change credentials, scheduled refresh, parameters.
Why?
Because we can have dozens and hundreds of reports built on top of this dataset.
If everyone can come and change semantic model parameters, data would be inconsistent during day (after each refresh).
If you want to change semantic model parameters, you need to refresh semantic model in order to see changes.
Summary: only one user can be the owner of dataset and control it.

For your scenario, you should use report slicers or RLS.

Report slicers (filters): each user can open report and choose specific values.
Example: user John Johnson wants to see sales only in Europe in 2024. We would provide these slicers on the report, not on dataset level.

RLS (row-level-security): our model contains sales for all continents, but i want that John Johnson can see only sales in Europe. Other continents will not be even visible for this user.

Cheers,
Nemanja