Forum Discussion

YasirFazal's avatar
YasirFazal
New Member
5 years ago
Solved

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

I need to implement Secruity on DataSet present in PowerBI Service

 

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)

  1.     Right click on Dataset 
  2.     Click on Security
  3.     All Roles that  i have defined in pbix file of Dataset  are present now 
  4.     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 

Which API call should I use and how ? C#.net is my key langauge here.