Forum Discussion
power bi rest api - execute query against dataset
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.
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.
Can your user use Analyze in Excel? Can they use DAX Studio? SSMS?
All of these work in our environment, for users that definitely do not have workspace access.
Agree, but having REST endpoints accessible makes automation a breeze (Power Automate) versus XMLA endpoints (Azure automation account, or SQL server instance or a machine that's constantly on etc)
Tested with dataset level explicit permissions - does not seem to work.
...bummer!
