Forum Discussion

JZT's avatar
JZT
Frequent Visitor
4 years ago
Solved

How to get model (not Dataset) ID - Part of getting RLS Roles and Role Members via Power BI REST API

Hello,   I was searching for a way to retrieve the RLS Roles and Role Members for Datasets using the Power BI REST API for Datasets located in the cloud service. The documentation doesn't have any ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Why not pull this via DMV queries from the XMLA endpoint?

     

    select * from $SYSTEM.TMSCHEMA_ROLES

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI JZT,

AFAIK, power bi REST API hasn't provided these types of features. In fact, power bi service already includes the feature to view and checking the dataset related RLS settings which not include in REST API.
For this scenario, you may need to manually trace power bi service operation and collect corresponding information(e.g. token, key, values, and request configurations...) to use programing language to manually invoke them.

Regards,
Xiaoxin Sheng

JZT's avatar
JZT
Frequent Visitor
4 years ago

Thanks for the reply.

Correct, Power BI REST API does not have this feature. There are many features I would love the API to one day have 🙂

Yes, tracing current operations is how I found the endpoint in my post. Unfortunately I have not been able to trace any calls to return the code I'm looking for.

Thanks