cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kelly_darren Frequent Visitor
Frequent Visitor

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 is assigned Browser privileges on the folder.

 

This enables the Users to view/acces each of the folder contents, however since the August update, Excel workbooks no longer download when clicked.  Paginated and Power BI reports operate as normal.

 

For the Users to access/open/download the Excel workbooks security on these files needs to be customised and elevated to Content Manager.

 

Has this change in security changed by design or by other reasons?  Is it only me or are there others experiencing the same?

 

Thanks

 

5 REPLIES 5
RahulBose Frequent Visitor
Frequent Visitor

Re: PBIRS August Update - Security Question

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?vie...

 

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

 

 

Regards

philipplenz Established Member
Established Member

Re: PBIRS August Update - Security Question

@mgmeyer

Can you please advice?

mackeris Frequent Visitor
Frequent Visitor

Re: PBIRS August Update - Security Question

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.

anetvg Frequent Visitor
Frequent Visitor

Re: PBIRS August Update - Security Question

I have a similar setup and I'm seeing the exact same behavior.  Has anyone found a way to fix this without granting extra security rights?

RahulBose Frequent Visitor
Frequent Visitor

Re: PBIRS August Update - Security Question

Hi All, 

 

Just a brief update to others who may also be experiencing this issue. 

 

I had initially granted access to all users as a workaround to this issue. However, as there was no resolution forthcoming, and to avoid users making changes directly to all files, I decided to grant elevated access only to excel files. That is, elevate access only to excel (.xlsx) files on the portal. 

 

Although this may be time consuming (updating access on a case by case basis), from a governance perspective, this seems to be a [slightly] more sustainable approach compared to blanket elevated access to all reports. 

 

Hope this assists and I welcome any feedback should there be a better alternative or (better yet) a fix!

 

Regards,
Rahul

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 203 members 2,128 guests
Please welcome our newest community members: