Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
YasirFazal
New Member

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.

 

 

 

 

1 ACCEPTED SOLUTION
2 REPLIES 2
GilbertQ
Super User
Super User

Hi @YasirFazal 

 

As far as I am aware this is not currently possible via the APIs.

 

You can vote for the idea on https://ideas.powerbi.com





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors