Forum Discussion

Sjong's avatar
Sjong
New Member
9 years ago
Solved

Blocking export on Power BI Report Server

What settings are available to block data being exported by viewers of my reports? In Power BI Service I can block this through the Tenant Settings. Does this also apply on Report Server? And if so, where can I manage this as admin?

  • This can be configured using SQL Server Management Studio and using the Advanced propery settings for the server:

     

    1. Connect SSMS to you PBIRS Server

    2. Right click on the Server node

    3. Select properties and then select the Advance tab page on the left

    4. You should see the export data property under User-defined as below

     

     

    Hope this helps, Thanks!

4 Replies

  • mgmeyer's avatar
    mgmeyer
    Power BI Team

    This can be configured using SQL Server Management Studio and using the Advanced propery settings for the server:

     

    1. Connect SSMS to you PBIRS Server

    2. Right click on the Server node

    3. Select properties and then select the Advance tab page on the left

    4. You should see the export data property under User-defined as below

     

     

    Hope this helps, Thanks!

    • Sjong's avatar
      Sjong
      New Member

      Exactly what I was looking for. Thank you mgmeyer!

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi All,

       

      Is it possible to block export per report?

       

      So if I have multiple reports on the same server, I want to allow users to export data on certain reports and I don't want them to be able to export on other reports. Is this possible and where do I find the settings?

      • vickyd's avatar
        vickyd
        Helper V

        Anonymous wrote:

        Hi All,

         

        Is it possible to block export per report?

         

        So if I have multiple reports on the same server, I want to allow users to export data on certain reports and I don't want them to be able to export on other reports. Is this possible and where do I find the settings?


        Yeah. Would be nice to have a report level option or better still visual level but I guess that would have to be on the Power BI Desktop side and not the Report Server.