Forum Discussion

codegirl's avatar
codegirl
Regular Visitor
2 years ago
Solved

Export paginated Report to tsv

How can I export a paginated report to tsv with a tab delimiter? In SSRS I could add an extension to the config file but that doesn't seem to work anymore.  The option still shows but the file has a comma instead of a tab for it's delimiter.

Export Data
On Premises Power BI report Server
  • d_gosbell's avatar
    d_gosbell
    2 years ago

    editing the config file definitely still works. Below is the config I'm using (note that there is an acutal TAB character in the FieldDelimiter)

     

          <Extension Name="TAB" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering" >
        <OverrideNames>  
          <Name Language="en-US">TSV (Tab Separated)</Name>  
        </OverrideNames>  
        <Configuration>
          <DeviceInfo>
            <SuppressLineBreaks>true</SuppressLineBreaks>
            <FileExtension>tsv</FileExtension>
            <FieldDelimiter xml:space="preserve">	</FieldDelimiter>
          </DeviceInfo>
        </Configuration>
      </Extension>

     

2 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    2 years ago

    editing the config file definitely still works. Below is the config I'm using (note that there is an acutal TAB character in the FieldDelimiter)

     

          <Extension Name="TAB" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering" >
        <OverrideNames>  
          <Name Language="en-US">TSV (Tab Separated)</Name>  
        </OverrideNames>  
        <Configuration>
          <DeviceInfo>
            <SuppressLineBreaks>true</SuppressLineBreaks>
            <FileExtension>tsv</FileExtension>
            <FieldDelimiter xml:space="preserve">	</FieldDelimiter>
          </DeviceInfo>
        </Configuration>
      </Extension>

     

    • codegirl's avatar
      codegirl
      Regular Visitor
      2 years ago

      I did not have my Field Delimiter set like yours. It worked after changing the field delimiter to match yours. I also had to stop reporting services and restart it using the Report Server Configuration Manager. Restarting the server did not work.