Forum Discussion
received request delete /api/v2.0/cacherefreshplans causes error 401 Unauthorized
Hello Microsoft Communinity,
When a user not part of Adminstrator group on the server tries to create or modify a schedule the error message :
an error has occured. try again later.
we found in the logs on the server :
.....Received request DELETE /api/v2.0/CacheRefreshPlans causes the error "
The request failed with HTTP status 401: Unauthorized."
the same user can create or modify a schedule during some minutes after an admin made the same action.
It seems like the "DELETE /api/v2.0/CacheRefreshPlans" is not authorized for this user who can do actions on the shedules whaile the cahe is not needed to be deleted. And since the cache should be deleted the "DELETE /api/v2.0/CacheRefreshPlans" is launched and as the user has no right to do it he ets the error The request failed with HTTP status 401: Unauthorized."
Anyone can help to fix this ?
BR,
Camille.
5 Replies
What version of Report Server are you using? There were issues like this a few releases ago, but I thought they were fixed now. If you are already on the Jan 2024 release then it might be better to raise a support ticket with Microsoft for a problem like this.
we insalled the PowerBI RS version of May 2023 ==> Build: 15.0.1112.41 / File version : 1.17.8546.6252
After checking the SPN part, we found an issue on the rights of the service account used on server. Applying the Negociate auth on it didn't resolve the issue :
Could the SSRS modute have an impact on the issue. As we need only Power BI Report Server we didn't configure SSRS on the server.
Any idea how to fix this issue ?
Thank you for your help.
Camille.
I don't think any of the 2023 releases had issues with subscriptions so you should be fine there.
There is not a separate SSRS module, all of the features of SSRS are included in Power BI Report Server.
One thing that might have happened is that something may have gone wrong with the deployment of database permissions or one of your DBAs might have accidentally altered these.
There is a role called RSExecRole that is required in order for subscriptions to work. You could follow the instructions here Create the RSExecRole - SQL Server Reporting Services (SSRS) | Microsoft Learn to make sure that role exists and is configured correctly
Hello/Bonjour,
Same error here since la update of PBIRS (May 2024) when whne creating schedule refres. Did you solve it?
Vous pouvez me répondre en français si voulez 😉
i fix my problem with this
reg add "HKLM\SYSTEM\CurrentControlSet\Control\Lsa" /v DisableLoopbackCheck /t REG_DWORD /d 1 /f
