Forum Discussion

CamilleS's avatar
CamilleS
Frequent Visitor
2 years ago

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 ...
delete cacherefreshplans
d_gosbell's avatar
d_gosbell
Super User
2 years ago

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.

CamilleS's avatar
CamilleS
Frequent Visitor
2 years ago

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.

  • d_gosbell's avatar
    d_gosbell
    Super User
    2 years ago

    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