I am attempting to implement a custom rendering extension (TabDelimitedRenderer) in Power BI Report Server to support exporting reports in a tab-delimited format. However, I am encountering the following issue:
Error Message:
"You have attempted to use a rendering extension that is either not registered for this report server or it is not supported in this edition of Reporting Services (rsRenderingExtensionNotFound)."
Steps Taken:
I created a custom rendering extension in C# that implements the IExtension interface.
I deployed the compiled DLL (TabDelimited.dll) to the following directory:
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
I updated the RSReportServer.config file with the following <Extension> entry:
<Extension Name="TabDelimited" Type="TabDelimitedRenderer, TabDelimited" />
Restarted the Power BI Report Server service.
Environment Details:
Power BI Report Server Version 2022
Developer Edition
Windows OS
Custom Extension Details:
Class Name: TabDelimitedRenderer
Assembly Name: TabDelimited
Questions:
Does Power BI Report Server support custom rendering extensions like SQL Server Reporting Services (SSRS)?
If supported, are there any additional steps required to enable the custom rendering extension?
Are there any limitations or restrictions in specific editions of Power BI Report Server that could cause this issue?
Could you provide guidance on resolving the rsRenderingExtensionNotFound error?
Code snippet ::
public class TabDelimitedRenderer : IExtension
{
public string LocalizedName => "Tab-Delimited";
public bool Render(
Stream reportStream,
NameValueCollection reportParameters,
NameValueCollection deviceInfo,
NameValueCollection clientCapabilities,
out string mimeType,
out string fileExtension,
out Encoding encoding,
out Stream outputStream)
{
mimeType = "text/plain";
fileExtension = "txt";
encoding = Encoding.UTF8;
outputStream = new MemoryStream();
try
{
using (StreamReader reader = new StreamReader(reportStream, encoding))
using (StreamWriter writer = new StreamWriter(outputStream, encoding, 1024, leaveOpen: true))
{
string line;
while ((line = reader.ReadLine()) != null)
{
string[] columns = line.Split(',');
writer.WriteLine(string.Join("\t", columns));
}
writer.Flush();
}
outputStream.Seek(0, SeekOrigin.Begin);
}
catch (Exception ex)
{
throw new ReportRenderingException("Error rendering Tab-Delimited format", ex);
}
return true;
}
public void SetConfiguration(string configuration) { }
public void GetRenderingResource(string resourceName, Stream resourceStream, out string mimeType)
{
mimeType = null;
}
