akweave1's avatar
akweave1
Regular Visitor
3 years ago
Status:
Done

BUG: Get Data from Azure Databricks - April Update

When trying to connect to Databricks I keep getting the error "Value cannot be null.  Parameter name:  s".  All the connection info is correct.  Also after I make the first attempt and get this error I am unable to try again, the OK button is grayed out.  I have to click Cancel and start the Get Data process all over again.  I should also mention that I think this is a bug in the April Desktop update because several coworkers have March 2023 version.  When they copy my steps and input they do not get the error and they can make changes and still be able to press OK again to retry.

Thank you!

Data Modeling

7 Comments

  • Whazeboo's avatar
    Whazeboo
    New Member
    3 years ago

    Same issue here. Even trying to view the source SQL code of a DataBricks-dashboard created in an earlier version of Power BI version results in error "Value cannot be null. Parameter name: s". This only happens in the April release (2.116.843.0).

     

    I tested it in the following earlier versions of Power BI where it works fine:

    2.112.1421.0 64-bit (January 2023)

    2.115.842.0 64-bit (March 2023)

     

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi akweave1

    Try to copy all folders in the below directory elsewhere, then clear the direcory and try again.

     

    For the Windows store installed app: 

    %userprofile%\Microsoft\Power BI Desktop Store App\ExtensionCache 

     

    For the PBI Desktop installed using offline/web installer:

    C:\Users\<username>\AppData\Local\Microsoft\Power BI Desktop\ExtensionCache 

     

    Best regards.

    Community Support Team_yanjiang

  • akweave1's avatar
    akweave1
    Regular Visitor
    3 years ago

    For now I uninstalled the earlier April release which was prior to 2.116.843.0 so maybe the bug was found and fixed after April 5?  Sorry I didn't make a note of the April release number before I uninstalled but I know it wasn't the latest.  It is working fine in my 2.115.663.0 version from March.  If I still have problems after updating I will try the Directory instructions.  Thanks!

  • akweave1's avatar
    akweave1
    Regular Visitor
    3 years ago

    I've installed Version: 2.116.884.0 for April 2023 and still get the same error when I try and pull data in with a SQL query, even just a simple Select * From

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago
    Status changed:
    Investigating
    to
    Accepted

    Hi akweave1 ,

    The issue was reported internally, now the workaroud is clear the directory I mentioned above. If there's any progress, I will update here.

     

    Best regards,

    Community Support Team_yanjiang

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago
    Status changed:
    Accepted
    to
    Done

    Hi akweave1 ,

    The issue was solved with the workaround provided.

     

    Best regards,

    Community Support Team_yanjiang

Completed Ideas