Forum Discussion

anetvg's avatar
anetvg
Frequent Visitor
8 years ago

Excel Spreadsheet Security issue on Power BI Report Server

We are storing our spreadsheets in the web portal so the users can download and view what they need.  We are currently not using OOS because we couldn't figure out how to make viewing the spreadsheet...
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi anetvg,

 

PG team provide a workaround below: 

 

“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. “

 

Please test it and feel free to tell us if you have any concern. 

 

Best Regards,
Qiuyun Yu 

  • anetvg's avatar
    anetvg
    Frequent Visitor
    8 years ago

    Hi there,

     

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

     

    Regards,

    Annette

  • billscribner's avatar
    billscribner
    Frequent Visitor
    7 years ago

    I am seeing this as an issue on my PBIRS.  Getting the same error.  I have tried the workaround suggested.  Able to download a spreadsheet as an admin, but other users cannot access and are receiving the following error:

     

    "The website decliend to show this webpage.  This website requires you to log in. "

     

    User is authenticated and has navigated thru PBIRS to the spreadsheet location.