Forum Discussion

PCorbitt's avatar
PCorbitt
Helper I
2 years ago
Solved

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 that setting again for a new report but can't find that option anymore. Was this ability eliminated, moved, replaced? 

Export Options
Report Formats
  • aduguid's avatar
    aduguid
    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>

     

     

  • PCorbitt's avatar
    PCorbitt
    2 years ago

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

5 Replies

  • aduguid's avatar
    aduguid
    Memorable Member
    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>

     

     

    • PCorbitt's avatar
      PCorbitt
      Helper I
      2 years ago

      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?

       

      • aduguid's avatar
        aduguid
        Memorable Member
        2 years ago

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

  • PCorbitt's avatar
    PCorbitt
    Helper I
    2 years ago

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