cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nakasdal
Microsoft
Microsoft

Power BI REST API as ADMIN

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

4 REPLIES 4
paherna
Community Support
Community Support

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.

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

up

dalebidwell
Frequent Visitor

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!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,304)