Forum Discussion
2 Replies
- SgtSmurf87New Member
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
- EnablePowerBIReportExportData
- EnablePowerBIReportMigrate
I did not have to restart Reporting Services for these changes to take effect.
- mselteneNew Member
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