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.

pikl's avatar
pikl
Frequent Visitor
3 years ago

Hi v-jingzhang,

I tried several different queries. Some refering to only one database, some referring to several. In neither case it is working.

I even tried queries as simple as the one below. I still get the error message.

 

 

SELECT
*
FROM schemaname.tablename

 

Best regards