Updating/ Changing the 'owner' information column in a dataverse table

[Jegaveer]

Hello All,

I have a table in dataverse and I am wondering how to modify  the 'owner' column (has more than 50,000 records) of the table .I am trying to implement to row level security for the below table and would like to test it.

I would like the instructor to see only the subjects (Class Name) which they handle. The assumption which I have is that, if I update the specific instructor's name as owner and grant them read access, they could see the records which they own. But I am not sure how to achieve this if we have more records in the owner column. Also, if I create 'team' and add all the instructors, would they still be able to see their own class name.

Sample table:

Class Name	Instructor	Owner
Biology	Jack	Sys Admin
Maths	John	Sys Admin
Biology	Jack	Sys Admin
History	Adam	Sys Admin
Geography	Paul	Sys Admin
History	Adam	Sys Admin

Thank you so much in advance! Really appreciate your comments.

[Jegaveer]

Hi @dpoggemann , thanks for the quick response. Yes, I am using the directquery to connect to the dataverse. The dataverse security works on the power bi desktop but not on the workspace. I'll be happy to provide any additional information which could be helpful.

Thank you so much and really appreciate your help!

Thanks!

Jega

[dpoggemann · Accepted solution]

Hi @Jegaveer ,

I think the key thing to look at is the connection (credentials) you are utilizing during direct query as discussed on this page https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about 

See the following:

Overall you need to make sure the credentials in the service are the end users credentials vs. a service account or the security will not work as expected.

[Jegaveer]

Hi @dpoggemann , Thanks for your response. I checked the credentials today and they are the same. It is the same account (name@onmicrosoft.com) that is in the security role (basic user and read-only access to some tables) in dataverse and in the power bi workspace (with admin privileges).

I also tried refreshing and re-publishing the report/ dataset, its still the same.

Thanks you so much!

Thanks!

Jega

[Jegaveer]

Hi @dpoggemann , it worked! thank you so much! I followed everything but missed to turn on the below check box in the 'edit credentials' in dataset settings in power bi workspace.

Thanks again!

Regards,

Jega