401 - Unauthorized error during Dataset Refresh with a reporting user

Question

Hi all,I'm running into an issue when refreshing a dataset with another user account.The connection is set to use another user account, the dataset is in a workspace in a Teams team.Side info: The dataset is using an on-premise Gateway.&nbsp;What I've tried so far:I've added the user to the Teams teamI've added permissions on the dataset for the user (basically everything that is available on the dataset level)I've logged into the on-premise-gateway with the user.The result I'm getting in my Flow is:Input (unformatted){&nbsp;&nbsp;&nbsp;&nbsp;"host":&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"connectionReferenceName":&nbsp;"shared_powerbi_2",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"operationId":&nbsp;"RefreshDataset"&nbsp;&nbsp;&nbsp;&nbsp;},&nbsp;&nbsp;&nbsp;&nbsp;"parameters":&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"groupid":&nbsp;"********-****-****-****-************",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"datasetid":&nbsp;"********-****-****-****-************"&nbsp;&nbsp;&nbsp;&nbsp;}}Output (unformatted){&nbsp;&nbsp;&nbsp;&nbsp;"statusCode":&nbsp;401,&nbsp;&nbsp;&nbsp;&nbsp;"headers":&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"X-PowerBI-Error-Info":&nbsp;"GroupsNotEnabled",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Strict-Transport-Security":&nbsp;"max-age=31536000;&nbsp;includeSubDomains",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"X-Frame-Options":&nbsp;"deny",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"X-Content-Type-Options":&nbsp;"nosniff",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Access-Control-Expose-Headers":&nbsp;"RequestId,X-PowerBI-Error-Info",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"RequestId":&nbsp;"********-001f-48c0-86f0-************",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Timing-Allow-Origin":&nbsp;"*",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"x-ms-apihub-cached-response":&nbsp;"false",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Date":&nbsp;"Tue,&nbsp;14&nbsp;Sep&nbsp;2021&nbsp;15:28:21&nbsp;GMT",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Content-Length":&nbsp;"283",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Content-Type":&nbsp;"application/json"&nbsp;&nbsp;&nbsp;&nbsp;},&nbsp;&nbsp;&nbsp;&nbsp;"body":&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"error":&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"code":&nbsp;401,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"source":&nbsp;"flow-apim-europe-001-francecentral-01.azure-apim.net",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"clientRequestId":&nbsp;"********-c245-4b32-83ed-************",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"message":&nbsp;"The&nbsp;response&nbsp;is&nbsp;not&nbsp;in&nbsp;a&nbsp;JSON&nbsp;format.",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"innerError":&nbsp;"Cannot&nbsp;read&nbsp;server&nbsp;response."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;}}&nbsp;From what I understand from the error code "401" and message "GroupsNotEnabled" this may point to a missing license for the end user, but in Admin center, I see the user has a "PowerBI Pro" license associated with the account.&nbsp;Any further ideas?

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;
Is your new account in the same organization as your old account?
New account should look like&nbsp;xxx@ABC.com&nbsp;and old account looks like zzz@ABC.com .
401 - Unauthorized error seems related to request credentials.&nbsp;
For reference:401 Unauthorized - HTTP | MDN (mozilla.org)
Did you use Rest API to refresh your dataset?
For reference:&nbsp;Datasets - Refresh Dataset In Group
Please check whether your App have&nbsp;Dataset.ReadWrite.All permission.
&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hello Rico, thanks for your answer.The new account is a cloud-only account thats domain is&nbsp;@mycompany365.onmicrosoft.com, while my account ends in&nbsp;@mycompany.tld.For my Flow I used the built-in method "New action" -&gt; "Refresh Dataset" while pointing the connector to my reporting user account, instead of my own account. See below screenshot.&nbsp;

Forum Discussion

401 - Unauthorized error during Dataset Refresh with a reporting user

2 Replies

Related content

Users gained unauthorized access to reports!!! How to stop them?

Issue with Power BI API Permissions for Datasets - 401 Unauthorized "PowerBINotAuthorizedException"

Use API to execute query to dataset giving Unauthorized Error

Refresh dataset api

Access Unauthorized