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

lbendlin's avatar
lbendlin
Super User
4 years ago

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

 

select * from $SYSTEM.TMSCHEMA_ROLES

  • JZT's avatar
    JZT
    Frequent Visitor
    4 years ago

    Thanks for your reply. I have tried querying DMVs, and yes that is one way to accomplish the goal. However:

    • I understand from the documentation that the account requires admin rights to query system DMVs which I very much want to avoid. The Web API can be scoped to read-only permissions.
    • I require 2 seperate calls (roles and members) since no joins are allowed where the Web API returns everything I need in a single call.
    • The Web API is orders of magnitude quicker from my testing with the rest of my solution currently being in PowerShell.

    Hopefully the Power BI REST API will be updated, I may create an Idea, but for now DMVs are not an ideal solution.

    If this ends up being the only way forward, I will gladly mark your reply as the solution.

    Thanks