Excel Spreadsheet Security issue on Power BI Report Server

Question

We are storing our spreadsheets in the web portal so the users can download and view what they need.&nbsp; We are currently not using OOS because we couldn't figure out how to make viewing the spreadsheet in PBRS optional if the user wanted to skip straight to downloading the spreadsheets.&nbsp; &nbsp;We have a folder with a set of shared spreadsheets and would like to allow certain groups to see only the spreadsheets that apply to them.&nbsp; However, whenever I hit the "Customize Security"&nbsp; link in the Secuirty section of the Manage spreadsheetname.xlsx, the spreadsheet will no longer download.&nbsp; Clicking on the spreadsheet brings up "The website cannot display the page" with a HTTP 500 Internal Server Error.&nbsp; I haven't changed anything, all I do is click that link and it no longer works.&nbsp; I'm an admin so I haven't removed my own access.&nbsp; If I click "Use same security as parent folder" everything goes back as it was and I can download the spreadsheet again.&nbsp; Is there a way for me to customize the security for my Excel spreadsheets?&nbsp; Is this a bug or am I doing something wrong (seems like it's a bug to me)?&nbsp; Thanks for any help you can provide.&nbsp;

v-qiuyu-msft · Answer

Hi&nbsp;anetvg,
&nbsp;
I can reproduce this issue, and already reported it internally: MSSOLVE&nbsp;118012917543919. Will update here once I get any information.&nbsp;
&nbsp;
Best Regards,Qiuyun Yu&nbsp;

anetvg · Answer

We are currently not using OOS because we couldn't figure out how to make viewing the spreadsheet in PBRS optional if the user wanted to skip straight to downloading the spreadsheets.&nbsp;&nbsp;We have a folder with a set of shared spreadsheets and would like to allow certain groups to see only the spreadsheets that apply to them.&nbsp; However, whenever I hit the "Customize Security"&nbsp; link in the Secuirty section of the Manage spreadsheetname.xlsx, the spreadsheet will no longer download.&nbsp; Clicking on the spreadsheet brings up "The website cannot display the page" with a HTTP 500 Internal Server Error.&nbsp; I haven't changed anything, all I do is click that link and it no longer works.&nbsp; I'm an admin so I haven't removed my own access.&nbsp; If I click "Use same security as parent folder" everything goes back as it was and I can download the spreadsheet again.&nbsp; Is there a way for me to customize the security for my Excel spreadsheets?&nbsp; Is this a bug or am I doing something wrong (seems like it's a bug to me)?&nbsp; Thanks for any help you can provide.&nbsp;

v-qiuyu-msft · Answer

Hi&nbsp;anetvg,
&nbsp;
PG team provide a workaround below:&nbsp;
&nbsp;
“Create a folder for what needed to set custom security. Set custom security to the folder, then move excel files to that folder and use parent security setting. “
&nbsp;
Please test it and feel free to tell us if you have any concern.&nbsp;
&nbsp;
Best Regards,Qiuyun Yu&nbsp;

anetvg · Answer

Hi there,&nbsp;Thank you!&nbsp; We actually have done this and it works.&nbsp; However, we have a lot of folders with just one Excel spreadsheet in them so still looking forward to the fix!&nbsp;Regards,Annette

billscribner · Answer

I am seeing this as an issue on my PBIRS.&nbsp; Getting the same error.&nbsp; I have tried the workaround suggested.&nbsp; Able to download a spreadsheet as an admin, but other users cannot access and are receiving the following error:&nbsp;"The website decliend to show this webpage.&nbsp; This website requires you to log in. "&nbsp;User is authenticated and has navigated thru PBIRS to the spreadsheet location. &nbsp;

Forum Discussion

Related content

Row Level Security - SSAS/Report Server

Role Level Security

Governance & Security

SECURITY

Page level security