If you modified the role definitions, check the roles to verify they contain the necessary tasks. The following instructions assume that you are using predefined roles. You must be a Content Manager and System Administrator to create or modify role definitions and role assignments on items and at the site level. On a native mode report server, create user role assignments that include tasks for using Report Builder. Role Assignments granting Report Builder access on a native mode Report Server To view a sample script that sets a report server property, see Script Deployment and Administrative Tasks.
#SHAREPOINT REPORT BUILDER HOW TO#
For more information about how to open this page, see Set Report Server Properties (Management Studio). To use Management Studio, connect to the report server and use the Advanced Server Properties page to set ShowDownloadMenuto false.
To set report server system properties, you can use Management Studio or script: Setting this property will disable Report Builder, Mobile Report Publisher, Power BI Desktop, and Power BI Mobile downloads for that report server. Report server administrators have the option of disabling the Report Builder download by setting the report server system property ShowDownloadMenu to false.
Enabling and Disabling Report Builderĭownloading Report Builder via the portal is enabled by default. Role assignments or permissions that make Report Builder available to individual users or groups.Īuthentication settings that determine whether user credentials can be passed through to the report server. Microsoft Report Builder is an ad hoc reporting tool that can be used with a SQL Server Reporting Services report server configured for either native mode or SharePoint integration mode.Īccess to Report Builder depends on the following factors: APPLIES TO: ✔️ SQL Server 2016 Reporting Services and later ✔️ Power BI Report Server