topic Re: Power BI Report Server "PUBLISH" Option - DISABLE / Remove in Report Server

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

khassan — Fri, 21 Jul 2023 17:03:38 GMT

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

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

SgtSmurf87 — Thu, 29 Feb 2024 15:41:33 GMT

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

Connect to the Reporting Services instance in SQL Server Management Studio (SSMS).
Right-click the instance name, select Properties.
In the "Select a page" pane, select Advanced.
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.

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

mseltene — Tue, 09 Apr 2024 14:18:03 GMT

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