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
_onto_'s avatar
_onto_
Icon for Helper I rankHelper I
3 years ago

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!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

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.