How to use custom assembly files within report and deploy to Power BI Service?

[Anonymous]

Hi all, 

I am currently working to migrate all existing SSRS to Power BI. I am running into an issue when I am trying to migrate a report that uses a custom assembly file. This dll file was not created by anyone on my team and was purchased so I am not able to access the actual code. 

This is the error I recieve when I try to deploy the report with the DLL (Im not sure why it says it cannot find the file specified since I am explicitly writing the full file path):

Operation returned an invalid status code 'BadRequest'
RdlWorkloadErrorCode:
PaginatedReportAuthoringError

RdlWorkloadErrorMessage:
Report is invalid. ErrorCode: rsErrorLoadingCodeModule, Details: Error while loading code module: BarcodeLib, Version=1.0.0.22, Culture=neutral, PublicKeyToken=null. Details: Could not load file or assembly BarcodeLib, Version=1.0.0.22, Culture=neutral, PublicKeyToken=null or one of its dependencies. The system cannot find the file specified.

PaginatedReportAuthoringError:
Report is invalid. ErrorCode: rsErrorLoadingCodeModule, Details: Error while loading code module: BarcodeLib, Version=1.0.0.22, Culture=neutral, PublicKeyToken=null. Details: Could not load file or assembly BarcodeLib, Version=1.0.0.22, Culture=neutral, PublicKeyToken=null or one of its dependencies. The system cannot find the file specified.

Any help or alternative solutions are appreciated!

Thank you in advance 🙂

[Anonymous]

Hi @Anonymous ,

Please pay attention to the following details.

To use custom assemblies in a report, you must first create the assembly, make it available to Report Designer, add a reference to the assembly in the report, and then use an expression in the report to refer to the methods contained in that assembly. When the report is deployed to the report server, you must also deploy the custom assembly to the report server.

To support the use of custom code assemblies in report definition files, two Report Definition Language (RDL) elements are included in the RDL specification: the CodeModules element and the Classes element.

See details : Using Custom Assemblies with Reports 

Migrate SQL Server Reporting Services reports to Power BI 

In addition, I have found a similar post, please refer to the following document about authentication credentials to see if it helps.

Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @Anonymous 

Currently as far as I am aware you cannot use custom assembly files in Paginated reports in Power BI Service.

[Amir23]

Hi @GilbertQ,

I was wondering if you have found or know of any workaround to custom DLL files not being supported within Paginated Reports in Power BI Services.

[GilbertQ]

Hi @Amir23 

Currently it is not possible.