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
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!
up
Hi @paherna , i do ! i'm using ADMIN User. as i said it works fine in the web page but not in the Flow.
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.