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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power BI REST API as A...
Power Automate
Unanswered

Power BI REST API as ADMIN

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi All,

need your help on a specific topic please. 

 

I'm trying to build a flow to extract data from the Power BI REST API with Admin User. When i do my test using the "Try It" in the page https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasetsasadmin it works fine. But, with my flow it doesnt work (with the same user). Here the message i've got :

 

Operation failed (401), see response below :

 

{
"cache-control": "no-store, must-revalidate, no-cache",
"content-type": "application/octet-stream",
"date": "Sun, 02 Aug 2020 16:58:44 GMT",
"home-cluster-uri": "https://wabi-us-east2-redirect.analysis.windows.net/",
"pragma": "no-cache",
"request-redirected": "true",
"requestid": "9623b954-8ddf-443e-9bb9-13a67d82729f",
"strict-transport-security": "max-age=31536000; includeSubDomains",
"x-content-type-options": "nosniff",
"x-frame-options": "deny"
}

 

 

thanks for your help

Categories:
I have the same question (0)
  • paherna Profile Picture
    on at

    Hi @nakasdal , 

     

    Thanks for reaching out in Communities! 

     

    Make sure that you have the appropriate permissions to be able to call the API as an Admin: 

     

    "The user must have administrator rights (such as Office 365 Global Administrator or Power BI Service Administrator) to call this API."

     

    Please reach out if you still have any issues after assigning such rights.

     

    Thanks!

     

    Community Support Team - Paola
    If this Post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • nakasdal Profile Picture
    Microsoft Employee on at

    Hi @paherna , i do ! i'm using ADMIN User. as i said it works fine in the web page but not in the Flow.

  • nakasdal Profile Picture
    Microsoft Employee on at

    up

  • dalebidwell Profile Picture
    10 on at

    Hi did you ever figure out what the issue was with this @nakasdal or @paherna I have exactly the same issue, it works correctly testing via the Power BI Rest API website and in the custom connector test page in the Power Automate\Apps portal, it will return data from non admin functions in the flow, but admin functions fail. I have Power BI \ Power Platform admin roles too. Thanks for any help!

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 506 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard