web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / User Permissions For Q...
Power Automate
Unanswered

User Permissions For Querying Power BI Datasets?

(1) 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:
I have the same question (14)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard