Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Power BI REST API as ADMIN

(0) ShareShare
ReportReport
Posted on by

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

  • dalebidwell Profile Picture
    dalebidwell 10 on at
    Re: Power BI REST API as ADMIN

    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!

  • nakasdal Profile Picture
    nakasdal on at
    Re: Power BI REST API as ADMIN

    up

  • nakasdal Profile Picture
    nakasdal on at
    Re: Power BI REST API as ADMIN

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

  • paherna Profile Picture
    paherna on at
    Re: Power BI REST API as ADMIN

    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.

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,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics