Forum Discussion

_onto_'s avatar
_onto_
Icon for Helper I rankHelper I
3 years ago

power bi rest api - execute query against dataset

Hi,   I have a scenario where user enquires about using the Power BI REST API to query dataset data (via Power Automate). The dataset in question is deployed via an app with build permissions enabl...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
My expectation was that this should be anough. Apparently it isn't.

It definitely is.  Has the user "installed" the app?  That is a one-time activity they must do before they can consume the XMLA endpoint.

_onto_'s avatar
_onto_
Icon for Helper I rankHelper I
3 years ago

They are specifically enquiring about the REST API.  The point I am raising is to do with users with build permissions (via app) not being able to cosume the REST endpoints. Particularly when one reads articles such as this one (and the emphasis on self service) and then it turns out things might not be as rosy.

 

So far:

- does not appear to be possible for users without workspace permissions to consume the REST endpoints but I cannot seem to find this clearly documented

- going the workspace permissions route defeats the whole point of having security defined at dataset level, the individual control over access to the different datasets that may exist in the same workspace, audiences and all of that

 

Hope I'm wrong about this.