Restricted Export Formats

PCorbitt — Wed, 26 Jun 2024 16:48:22 GMT

Hello, experts! I created a report a few months ago in Report Builder and at that time I was able to restrict the export options to just Excel and PDF from a dropdown list. I urgently need to use that setting again for a new report but can't find that option anymore. Was this ability eliminated, moved, replaced?

Re: Restricted Export Formats

aduguid — Wed, 26 Jun 2024 22:54:04 GMT

You'll need to update your config file on the report server. Once you open the file in Notepad you can remove any extensions you don't want your users to export. Search for the "Render" section. Make sure you take a backup before making any changes.

C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config

<Render> <Extension Name="WORDOPENXML" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordOpenXmlRenderer.WordOpenXmlDocumentRenderer,Microsoft.ReportingServices.WordRendering"/> <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering" Visible="false"/> <Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/> <Extension Name="PPTX" Type="Microsoft.ReportingServices.Rendering.PowerPointRendering.PptxRenderingExtension,Microsoft.ReportingServices.PowerPointRendering"/> <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/> <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/> <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"> <Configuration> <DeviceInfo> <DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing> </DeviceInfo> </Configuration> </Extension> <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/> <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/> <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering"/> <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/> <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/> <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"> <Configuration> <DeviceInfo> <DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing> </DeviceInfo> </Configuration> </Extension> <Extension Name="HTML5" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html5RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"> <Configuration> <DeviceInfo> <DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing> </DeviceInfo> </Configuration> </Extension> <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/> </Render>

Re: Restricted Export Formats

PCorbitt — Wed, 03 Jul 2024 13:12:55 GMT

Thank you for your response! How do I get to the Report Server? Is it software I need to download or is it a part of Report Builder that I haven't discovered yet?

Re: Restricted Export Formats

aduguid — Wed, 03 Jul 2024 14:06:01 GMT

Are you deploying the report to an on premises server or to the service (cloud)?

Re: Restricted Export Formats

PCorbitt — Wed, 03 Jul 2024 15:33:22 GMT

It is a part of a PBI report which is published to a Workbook, where the Paginated Report is also stored. I think that means my answer is "to the service (cloud)".

Re: Restricted Export Formats

PCorbitt — Fri, 02 Aug 2024 15:53:24 GMT

This was such a simple problem. The answer was using the PBI visualization Visual>Export settings.

topic Re: Restricted Export Formats in Report Server

Restricted Export Formats

Re: Restricted Export Formats

Re: Restricted Export Formats

Re: Restricted Export Formats

Re: Restricted Export Formats

Re: Restricted Export Formats