Forum Discussion
power bi rest api - execute query against dataset
I think I have been reading your question wrong - apologies.
For running a query against the REST API you need to authenticate. Either via the built-in authentication in Power Automate, or by registering an app in Azure that has the right permissions AND SCOPE . Once you have that then your process no longer depends on the user running the REST API call.
I don't think you read it wrong. Main gripe is with the requirement to grant and manage permissions at workspace level. For a number of reasons: visibility over everything in that workspace, maintenance overhead, the huge imbalance between required data scope and actual data scope i.e. user need only access a fraction of the data in one dataset but gets visibility over the full dataset, all other datasets in the workspace, and whatever else is in that workspace.
The Azure app approach is the slightly more palatable one since there's probably less maintenance overhead in the long run. But it doesn't address the visibility over everything in that workspace.