Forum Discussion

pikl's avatar
pikl
Frequent Visitor
3 years ago
Solved

Error message: The value cannot be NULL. Parameter name: s

Hey everyone, I've been querying databricks tables from power bi successfully for a while now. However, suddenly I cannot use the native query  anymore. When I try to apply it I get the following er...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi all

     

    This issue is planned to be fixed in the next version. Currently as a workaround, you can clear the content on these folders:

     

    For the Windows store installed app: 

    %userprofile%\Microsoft\Power BI Desktop Store App\ExtensionCache needs be deleted

     

    For the PBI Desktop installed using offline/web installer:

    C:\Users\<username>\AppData\Local\Microsoft\Power BI Desktop\ExtensionCache needs to be deleted

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi pikl 

 

Can you share the native query statement? Does it refer to only one database? 

 

Best Regards,
Community Support Team _ Jing

Whazeboo's avatar
Whazeboo
New Member
3 years ago

I have the same issue since Version: 2.116.843.0 64-bit (april 2023).

Pressing the 'OK'-button in the Databricks-window returns error "Value cannot be null. Parameter name: s".

See for example screen below where an existing statement created in an earlier version of Power BI results in the error: