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 Whazeboo 

 

Thank you for the information. The issue has been submitted internally. I will track the status and progress. Once I get any good news I will update it here. 

 

Currently I get a workaround that you may have a try: 

Clear the directory C:\Users\<username>\AppData\Local\Microsoft\Power BI Desktop and try again. 

If you worry that this may clear too much data, you can copy all folders in the directory to somewhere else, then clear the directory. 

 

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

  • pikl's avatar
    pikl
    Frequent Visitor
    3 years ago

    Hi v-jingzhang ,

    Thank you very much for the information. Unfortunately, the workaround did not work for me. 

     

    However, it might be helpful for other people to know that it is still possible to use a native query statement directly in the power query editor. 

     

    Best Regards