Forum Discussion

kelly_darren's avatar
kelly_darren
Advocate II
7 years ago

PBIRS August Update - Security Question

Hi   We have folder security in operation on PBIRS.  Each folder can contain some Paginated Reports, Power BI reports and Excel workbooks.  Security on the folder is maintained via AD Groups which ...
PBIRS on premise
security
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

 

We operate in a similar way to that mentioned by kelly_darren above and are also experiencing this issue.

 

This issue comes following our recent upgrade to August 2018 PBIRS. That is, users in our organisation with Security level of "Browser" being unable to access/open/download Excel workbooks. They receive a HTTP 403 error, unless they are elevated to an access level of Content Manager. Our users are successfully able to open Power BI and Paginated reports with no problems in the Browser role.

 

It may or may not be related, but we have noted that there is a comment on the SQL SSRS 2017 upgrade (released on 31st August 2018) "Browser Role Behaviour Change". Perhaps this is related to the issue (ie. caused via this code being merged into PBIRS, or perhaps not merged in?)

https://docs.microsoft.com/en-us/sql/reporting-services/change-log-sql-server-reporting-services?view=sql-server-2017

 

I will echo kelly_darren's questions in asking whether this has been changed by design?

 

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    @mgmeyer

    Can you please advice?

  • mackeris's avatar
    mackeris
    Regular Visitor
    7 years ago

    We have the same issue. We are on Sql 2017 db engine but do not have SSRS installed. We only have the seperate pbirs service installed and Aug 2018 update broke our uploaded excel reports. Browser throws 403 error states users must authenticate...but they are authenticated and can run any of the other reports in the same folder.