Forum Discussion

khassan's avatar
khassan
Regular Visitor
3 years ago

Power BI Report Server "PUBLISH" Option - DISABLE / Remove

With Power BI Report Server Jan-2023 release, is it possibel to "DISABLE" or "REMOVE" Publish option?

2 Replies

  • To disable the Publish feature in SQL Server Reporting Services (SSRS) 2019,

    1. Connect to the Reporting Services instance in SQL Server Management Studio (SSMS).
    2. Right-click the instance name, select Properties.
    3. In the "Select a page" pane, select Advanced.
    4. Under User-Defined, set these items to False
      1. EnablePowerBIReportExportData
      2. EnablePowerBIReportMigrate

    I did not have to restart Reporting Services for these changes to take effect.

     

  • To disable the Power BI publish features, you can use the following code: 

     

    select * from [reportserver].[dbo].[configurationinfo] where name like '%power%'
    go
    update [reportserver].[dbo].[configurationinfo] set value = 'False' where name = 'enablepowerbireportexportdata'
    update [reportserver].[dbo].[configurationinfo] set value = 'False' where name = 'enablepowerbireportexportunderlyingdata'
    update [reportserver].[dbo].[configurationinfo] set value = 'False' where name = 'enablepowerbireportmigrate'
    go