Skip to main content
Microsoft Idea

Power BI

Needs Votes

Can I Add/update Row-level security of dataset via Rest API? yesterday

Vote (41) Share
Yasir Fazal's profile image

Yasir Fazal on 01 Apr 2021 14:35:03

New Member
Scenario

1) Download the Dataset and Add roles + Related filteres using Manage Roles options in the PowerBI Desktop.

2) Upload the Dataset

3) (This step which i really would like to Automate using REST api calls)

Right click on Dataset
Click on Security
All Roles that i have defined in pbix file of Dataset are present now
I add email address as Members and click save


Requirment

I need to automate the step 3 using Rest API.

I have a mapping database(A simple Excel file) in which i have a mapping of Email to Role e.g 500 Records

I only need to read that mapping and make RESTAPI call for each of the record present in my mapping database



Once completed. If some one opens the security of DataSet he should see the mapping in ROW -LEVEL-Security Section



Ask/IDEA
Please create a RESTAPI Call through which a developer can Implement Row-Level-Security in DATASET

Comments (2)
Yasir Fazal's profile image Profile Picture

Paul Holmes on 13 Feb 2023 21:32:29

RE: Can I Add/update Row-level security of dataset via Rest API? yesterday

This would increase our flexibility hugely. Our primary dataset requires 300 roles each mapped to an AD group, and the number of roles continues to increase. Apply this mapping or auditing using the UI can take several hours, and changes have risk of human error.

Yasir Fazal's profile image Profile Picture

Pradeep Jain on 17 Jan 2023 07:08:13

RE: Can I Add/update Row-level security of dataset via Rest API? yesterday

I need this feature to automate the publish of dataset completely.