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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,602)