Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

User Permissions For Querying Power BI Datasets?

(0) ShareShare
ReportReport
Posted on by 8
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:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics