Forum Discussion

Don-Bot's avatar
Don-Bot
Icon for Helper V rankHelper V
1 year ago
Solved

Azure Databricks Query: The key didn't match any rows in the table

I am attempting to use the azure databricks connection but instead of searching for a table I want to use a query.  However, even though I am throwing in a very simple query that works in my databric...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    Hi Don-Bot ,

     

    If I'm not mistaken you need to define the default catalog on the Databvricks connection when using a query, even if it's not the catalog you want to use on the sql query just add one on the connection string.

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
1 year ago

Hi Don-Bot ,

 

This is very picky you when you want to use a query you need to define the optional fields but also add them to the query.

 

What I have done in my use cases I have made parameter for each one and a SQLQuery line to be pickedup that way when I want to update everything I just need to change the parameters.

Don-Bot's avatar
Don-Bot
Icon for Helper V rankHelper V
1 year ago

Hi MFelix ,

I agree on the parameters, and for my other models I am heavily invested in the parameters but I'm not using queries.  Just pointing to already created tables/views.  This was a special need and was trying to setup a dummy pbi to make sure it would work.  

 

Quite annoying but thanks for the help.