Power Platform Community Forum Thread Details

User Permissions For Querying Power BI Datasets?

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."
                        }
                    }
                ]
            }
        }
    }
}

Categories:

Licensing

Quick Links