Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
pikl
Frequent Visitor

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 error mesage:

 

The value cannot be NULL.
Parameter name: s

 

Note, when I do not specify a native query and only query a specific database, it is still working.

 

Can anyone give me adivice on how to get the native query working again?

 

Thank you very much

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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.

View solution in original post

11 REPLIES 11
Syndicate_Admin
Administrator
Administrator

When is this next version planned? I have the same problem.

v-jingzhang
Community Support
Community Support

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.

Syndicate_Admin
Administrator
Administrator

G'day mate. Any update on this one? I have to write a direct query and pass dynamic M into it.

adamjackson08
New Member

Hi,

Try adding your Default Catolog name, ours is:
hive_metastore

adamjackson08_1-1682687903578.png

 

 


Thanks
Adam

v-jingzhang
Community Support
Community Support

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.

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

pikl
Frequent Visitor

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

 

ChielFaber
Super User
Super User

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.

Syndicate_Admin
Administrator
Administrator

I am having the same issue, after the new release of April 2023

v-jingzhang
Community Support
Community Support

Hi @pikl 

 

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

 

Best Regards,
Community Support Team _ Jing

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:

Powerbi_databricks_error.png

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Top Solution Authors
Top Kudoed Authors