Power BI
Needs VotesCan I Add/update Row-level security of dataset via Rest API? yesterday
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)
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.
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.