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.

ChielFaber's avatar
ChielFaber
Super User
3 years ago

It might be unrelated but had some problems myself with the connectors. Are you an admin of the data gateway? I had a connector problem that got solved after obtaining admin rights to the gateway.