Forum Discussion
PCorbitt
2 years agoHelper I
Restricted Export Formats
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 tha...
- 2 years ago
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> - 2 years ago
This was such a simple problem. The answer was using the PBI visualization Visual>Export settings.
aduguid
2 years agoMemorable Member
Are you deploying the report to an on premises server or to the service (cloud)?
PCorbitt
2 years agoHelper I
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)".