Forum Discussion

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
7 months ago
Solved

Power BI & Databricks ADBC connector

Hello,

Have any of you pulled successfully the beta implementation (2.0) ofthe  Databricks connector in Power BI Desktop (non-store version, but also store one).

 

I am getting this error.

ADBC: Could not load file or assembly Microsoft.IO.RecyclableMemoryStream

 

I have the latest version of PBI Desktop Version: 2.150.2102.0 64-bit

 

I do use the Power Query connector options correctly, and I can successfully authenticate, but it only fails after that. Any suggestions on how to make it work?;

 

I want to precisely use the ADBC connector, as I wanna benchmark it, so going back to the default Implementation is not the solution here.

4 Replies

  • vojtechsima This error occurs when your application or service cannot locate the required Microsoft.IO.RecyclableMemoryStream assembly or one of its dependencies at runtime. It often happens due to missing DLLs, version mismatches, or deployment issues.

     

    A common cause is that the assembly is available during development but not included in the deployment package, or a different version is being loaded than expected. To fix this, first ensure the correct version is referenced in your project. If using NuGet, explicitly install the required version:

     

    dotnet add package Microsoft.IO.RecyclableMemoryStream --version 3.0.1

    • vojtechsima's avatar
      vojtechsima
      Icon for Super User rankSuper User

      GeraldGEmerick  I don't think that's relevant here; that dll should come directly with Power BI Desktop, as it's not a project where you would add packages or any other things really.

      • GeraldGEmerick's avatar
        GeraldGEmerick
        Icon for Memorable Member rankMemorable Member

        vojtechsima I agree that the DLL for it should come as part of the Desktop but it's possible that it does not since the connector is beta. I think it is worth a shot to try installing it manually and see if that solves the problem.

  • Fixed with the latest Power BI Desktop (standalone) release.