I want to use
Run A Query Against A Dataset Power BI connector to get the fields associated with a UID out of a dataset; literally "type UID, click button, get properties associated with UID."
The flow is successful when I use it, but not when my coworker uses it. I'm aware there are
permissions requirements for the REST API:
- I do not have access to our tenant settings, so I can't confirm that the Dataset Execute Queries REST API setting is enabled, however; If it were disabled, I think I would receive an error when I run the Flow, so I don't believe this is the issue.
- I have Admin permissions to the Workspace that contains my dataset. My coworker's permissions are "Workspace Viewer, App (Reshare, Build)"; does that not meet the "Read" and "Build" permission requirements?
- Neither my coworker nor myself have Premium Power Automate licenses.
- Both my coworker and I have Power BI Pro licenses.
The error output when my coworker runs the Flow is:
{
"statusCode": 404,
"headers": {...},
"body": {
"error": {
"code": "PowerBIEntityNotFound",
"pbi.error": {
"code": "PowerBIEntityNotFound",
"parameters": {},
"details": [
{
"code": "DetailsMessage",
"detail": {
"type": 1,
"value": "You cannot query the dataset '<uuid-of-my-dataset>'
by using the REST API because the dataset was not found or you do
not have the required permissions. Please contact a workspace
admin or a dataset owner to grant you the required permissions.
See https://go.microsoft.com/fwlink/?linkid=2190204 for more info
on required permissions."
}
}
]
}
}
}
}